forum.coppermine-gallery.net
Dev Board => cpg1.4 Testing/Bugs => cpg1.4 Testing/Bugs: FIXED/CLOSED => Topic started by: asterix on September 04, 2005, 06:58:48 am
-
I have successfully installed CPG 1.4 in the same database with my phpbb,and the standalone gallery ran well. Howerver, at the final step, the error occured when I hit the 'Start bridging wizard' tab.
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fimg376.imageshack.us%2Fimg376%2F3420%2Ferror6yv.gif&hash=3d8711e965ff326fa1f1f4c483850c1b5bbc2acd)
I tried to access Coppermine by using bridgemgr.php but the error message was still fatal error.
Then I had to delete gallery tables in the database , and installed the gallery once again, but there 's still the same problem.
My site info:
Operating system Linux
PHP version 4.4.0
MySQL version 4.0.25
My board: http://diendansaomai.net/forums/
Gallery: http://diendansaomai.net/gallery/
Thanks
-
Enable debug mode and post the actual error.
-
...and make sure that you have the most recent cvs checkout. It wouldn't have been necessary to delete and start over - accessing the database directly (using a tool like phpMyAdmin) and disabling bridging there would have been enough.
-
thanks, but I didn't the column to set in order to disable the bridge.
I did fresh install again (standalone, in the same database with my phpbb board); and when I enable the debug mod, I got the error message.
(still standalone version, not intergrated with phpbb)
USER:
------------------
Array
(
[ID] => 539a16cdd893868800fad91ed342072a
[am] => 1
[lang] => english
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_name] => onlytime
[groups] => Array
(
)
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 3
[ufc_min] => 3
[custom_user_upload] => 0
[num_file_upload] => 5
[num_URI_upload] => 3
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[upload_form_config] => 3
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content, player FROM cpg140_filetypes; (0s)
[1] => select * from cpg140_plugins order by priority asc; (0s)
[2] => delete from `diendan_***`.cpg140_sessions where time<1125888246 and remember=0; (0s)
[3] => delete from `diendan_***`.cpg140_sessions where time<1124682246; (0s)
[4] => select user_id from `***`.cpg140_sessions where session_id=md5("0b4c8e7e0a4f0164025c1c6d916a08073454c6846b0b2bd7351e698fce1bd839"); (0s)
[5] => select user_id as id, user_password as password from `diendan_***`.cpg140_users where user_id=1 (0s)
[6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `diendan_***`.cpg140_users AS u INNER JOIN `diendan_***`.cpg140_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
[7] => SELECT user_group_list FROM `diendan_***`.cpg140_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
[8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg140_usergroups WHERE group_id in (1) (0s)
[9] => SELECT group_name FROM cpg140_usergroups WHERE group_id= 1 (0s)
[10] => update `diendan_***`.cpg140_sessions set time='1125891846' where session_id=md5('0b4c8e7e0a4f0164025c1c6d916a08073454c6846b0b2bd7351e698fce1bd839'); (0s)
[11] => SELECT user_favpics FROM cpg140_favpics WHERE user_id = 1 (0s)
[12] => DELETE FROM cpg140_banned WHERE expiry < '2005-09-05 03:44:06' (0s)
[13] => SELECT * FROM cpg140_banned WHERE (ip_addr='***' OR ip_addr='***' OR user_id=1) AND brute_force=0 (0s)
[14] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '' ORDER BY pos (0s)
[15] => SELECT aid FROM cpg140_albums as a WHERE category>=10000 (0s)
[16] => SELECT count(*) FROM cpg140_pictures as p, cpg140_albums as a WHERE p.aid = a.aid AND category >= 10000 (0s)
[17] => SELECT cid, name, description, thumb FROM cpg140_categories WHERE parent = '1' ORDER BY pos (0s)
[18] => SELECT aid FROM cpg140_albums as a WHERE category = '0' (0s)
[19] => SELECT count(*) FROM cpg140_albums as a WHERE 1 (0s)
[20] => SELECT count(*) FROM cpg140_pictures as p LEFT JOIN cpg140_albums as a ON a.aid=p.aid WHERE 1 (0s)
[21] => SELECT count(*) FROM cpg140_comments as c LEFT JOIN cpg140_pictures as p ON c.pid=p.pid LEFT JOIN cpg140_albums as a ON a.aid=p.aid WHERE 1 (0s)
[22] => SELECT count(*) FROM cpg140_categories WHERE 1 (0s)
[23] => SELECT sum(hits) FROM cpg140_pictures as p LEFT JOIN cpg140_albums as a ON p.aid=a.aid WHERE 1 (0s)
[24] => SELECT COUNT(*) FROM cpg140_pictures WHERE approved = 'NO' (0s)
[25] => SELECT count(*) FROM cpg140_albums as a WHERE category = '0' (0s)
[26] => SELECT COUNT(*) from cpg140_pictures WHERE approved = 'YES' (0s)
[27] => SELECT * FROM cpg140_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 8 (0s)
[28] => SELECT COUNT(*) from cpg140_pictures WHERE approved = 'YES' (0s)
[29] => SELECT * FROM cpg140_pictures WHERE approved = 'YES' ORDER BY pid DESC LIMIT 0 ,8 (0s)
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.4.0 - OK
------------------
mySQL version: 4.0.25-standard
------------------
Coppermine version: 1.4.1(beta)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support:
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:
==========================
Module: mysql
------------------
module doesn't exist
==========================
Module: zlib
------------------
module doesn't exist
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value | | | | | | | | | | | | | | | | | | | |
==========================
email
------------------
Directive | Local Value | Master Value | | | | | | | |
==========================
Size and Time
------------------
Directive | Local Value | Master Value | | | | | | | |
==========================
Page generated in 0.078 seconds - 30 queries in 0 seconds - Album set : ; Meta set: ;
Notices
/index.php
* Notice line 726: Undefined variable: file
/include/functions.inc.php
* Warning line 2225: phpinfo() has been disabled for security reasons
* Warning line 2225: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
* Warning line 2329: phpinfo() has been disabled for security reasons
Thanks for your support
-
You still haven't posted the actual SQL error message. Don't post debug output unless we request it.
-
thanks,
but where is the "the actual SQL error message" ? I don't know where it is.
-
The one you refered to in your first posting:
Howerver, at the final step, the error occured when I hit the 'Start bridging wizard' tab.
What error occured exactly? If you have no idea what the actual error message is, attach a screenshot to your posting. Make sure to disable notices_display in coppermine's config, we only need the plain debug_out option turned on.
-
sorry for making you confused.
Here's the details:
First the error occured when I installed the gallery and tried to intergrate it to the board right after. At the final step as refered in the screenshot in the first post, when I hit the start bridging wizard, the message occured :
(https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fimg278.imageshack.us%2Fimg278%2F6379%2Ferror14ow.jpg&hash=af7e10cf14bfb43ef71086c01c804ffca0cd0242)
I loged in first as admin (of the phpbb) and I received the error message :
Fatal error :
While executing query "SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as priv_upl_need_approval FROM cpg140_usergroups WHERE group_id in ()" on 0
mySQL error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
I didn't know how to disable the bridge. First, I tried to used bridgemgr.php, but the same error message occured (I loged in with account when installing the gallery). Then I did go to the database, looking for the cpg140_bridge and the cpg140_config , but didn't know exactly what column's values to set).
Regards
p.s
that you have the most recent cvs checkout.
I don't know how to get these? CVS?
-
Read the sticky thread on this board to find out about CVS, particularly http://forum.coppermine-gallery.net/index.php?topic=7947.msg77748#msg77748
Please note that cpg1.4.x goes unsupported and it is meant for experienced users only on non-production environments for testing.
-
marking as "Invalid" - not knowing about cvs means that you're using an outdated version, so you're not qualified as beta tester, sorry.