forum.coppermine-gallery.net
Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: LATH on February 12, 2005, 05:40:14 am
-
I installed Coppermine on about 2/6/2005 and now I'm getting this error:
Fatal error: Cannot redeclare clean_words() (previously declared in /home/johnlat/public_html/gallery/include/search.inc.php:44) in /home/johnlat/public_html/gallery/include/search.inc.php on line 44
It can be reproduced by:
1) go to http://www.johnlathrop.com/gallery/index.php
2) Click on Abell Family
3) Search using the word vivian
4) Click on any picture but the first picture
I used the "batch add files" functionality to add the pictures and a series of SQL statements like the following to add title, caption, etc:
UPDATE cpg132_pictures SET title='Emeline (ELIZA) Kidwell',caption=' ',keywords='Emeline (ELIZA) Kidwell Indianapolis, Indiana',user1='067',user2='Indianapolis, Indiana',user3='est 1870',user4='Ora Mae Suitcase' WHERE filename='067.jpg';
Some of the captions include HTML like   and <br>...this info came from another database that made use of the simple html. As I type this I'm wondering if that is the cause of my problem.
???
-
nope...I removed all of the and <br>...still get the error... :\'(
-
I tried one more thing:
1) Delete category
2) Delete album
(I only had one category and one album...so, this cleaned out everything)
3) Created category and album
4) Used Batch Add to add pictures to album again
5) Gave several pictures the title "vivian"...to keep it simple
6) Repeated the steps in my initial message and now the message is "No image to display"
:-[ :-\\ :\'(
-
Cannot redeclare clean_words()
Means you are trying to declare a function twice.
Either you are including the code twice and it's causing this error, or you've put the function clean_words in two different files.
use a text search utility that can search all of your php files for "function clean_words" report back the files that it exists in.
If you don't find any duplicates you can try using php's require_once or include_once functions on whatever line is including/requireing search.inc.php.
-
one last idea:
1) set the keyword equal to the tile...just so the keyword is populated:
UPDATE cpg132_pictures SET keywords='vivian' WHERE title='vivian';
Still get the error: No image to display File: /home/johnlat/public_html/gallery/displayimage.php - Line: 590
Here is the debug output:
USER:
------------------
Array
(
[ID] => eb48518a5e1fc97063ffe4404759df87
[am] => 1
[liv] => Array
(
- => 13
[1] => 2
[2] => 6
[3] => 10
[4] => 12
)
[search] => ###18th person
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_group] => 1
[user_active] => YES
[user_name] => ********
[user_password] => ********
[user_lastvisit] => 2005-02-12 01:30:30
[user_regdate] => 2005-02-06 13:21:20
[user_group_list] =>
[user_email] =>
[user_website] =>
[user_location] =>
[user_interests] =>
[user_occupation] =>
[user_actkey] =>
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 0
[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
[groups] => Array
(
[1] => 1
)
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg132_filetypes;
[1] => SELECT * FROM cpg132_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'ede58112932a9816546fd935683ac2c9'
[2] => 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 cpg132_usergroups WHERE group_id in (1)
[3] => SELECT group_name FROM cpg132_usergroups WHERE group_id= 1
[4] => DELETE FROM cpg132_banned WHERE expiry < 1108190024
[5] => SELECT * FROM cpg132_banned WHERE ip_addr='69.110.68.148' OR ip_addr='69.110.68.148' OR user_id=1
[6] => SELECT pid FROM cpg132_pictures WHERE CONCAT(' ', keywords, ' ') LIKE '% 18th %' OR filename LIKE '%18th%' OR title LIKE '%18th%' OR caption LIKE '%18th%' OR user1 LIKE '%18th%' OR user2 LIKE '%18th%' OR user3 LIKE '%18th%' OR user4 LIKE '%18th%'
[7] => SELECT pid FROM cpg132_pictures WHERE CONCAT(' ', keywords, ' ') LIKE '% person %' OR filename LIKE '%person%' OR title LIKE '%person%' OR caption LIKE '%person%' OR user1 LIKE '%person%' OR user2 LIKE '%person%' OR user3 LIKE '%person%' OR user4 LIKE '%person%'
[8] => SELECT COUNT(*) FROM cpg132_pictures WHERE ( pid in ('') and pid in ('') ) AND approved = 'YES'
[9] => SELECT * FROM cpg132_pictures WHERE ( pid in ('') and pid in ('') ) AND approved = 'YES' LIMIT 1 ,1
)
==========================
GET :
------------------
Array
(
[album] => search
[cat] => 0
[pos] => 1
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.22-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 4.0.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/johnlat:/usr/lib/php:/usr/local/lib/php:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.057 seconds - 10 queries in 0.001 seconds - Album set :
-
donnoman already told you what to do.
-
donnoman and kegobeer saw one line and jumped to a conclusion. I guess I need to post this again without the alluring subject line.
By the way, I have not change your source code in any way. This is a standard install. If you were to read all of my messages you would see that I changed the data and the error message changed. Conclusion->>"error messages aren't always what they seem"
-
No image to display after search >:( >:( >:(
This can be reproduced by:
1) go to http://www.johnlathrop.com/gallery/index.php
2) Click on Abell Family
3) Search using the word vivian
4) Click on any picture but the first picture
I used the "batch add files" functionality to add the pictures. I gave several pictures the title and keyword "vivian"...to keep it simple.
Here is the debug output:
USER:
------------------
Array
(
[ID] => eb48518a5e1fc97063ffe4404759df87
[am] => 1
[liv] => Array
(
- => 13
[1] => 2
[2] => 6
[3] => 10
[4] => 12
)
[search] => ###18th person
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_group] => 1
[user_active] => YES
[user_name] => ********
[user_password] => ********
[user_lastvisit] => 2005-02-12 01:30:30
[user_regdate] => 2005-02-06 13:21:20
[user_group_list] =>
[user_email] =>
[user_website] =>
[user_location] =>
[user_interests] =>
[user_occupation] =>
[user_actkey] =>
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 0
[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
[groups] => Array
(
[1] => 1
)
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg132_filetypes;
[1] => SELECT * FROM cpg132_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'ede58112932a9816546fd935683ac2c9'
[2] => 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 cpg132_usergroups WHERE group_id in (1)
[3] => SELECT group_name FROM cpg132_usergroups WHERE group_id= 1
[4] => DELETE FROM cpg132_banned WHERE expiry < 1108190024
[5] => SELECT * FROM cpg132_banned WHERE ip_addr='69.110.68.148' OR ip_addr='69.110.68.148' OR user_id=1
[6] => SELECT pid FROM cpg132_pictures WHERE CONCAT(' ', keywords, ' ') LIKE '% 18th %' OR filename LIKE '%18th%' OR title LIKE '%18th%' OR caption LIKE '%18th%' OR user1 LIKE '%18th%' OR user2 LIKE '%18th%' OR user3 LIKE '%18th%' OR user4 LIKE '%18th%'
[7] => SELECT pid FROM cpg132_pictures WHERE CONCAT(' ', keywords, ' ') LIKE '% person %' OR filename LIKE '%person%' OR title LIKE '%person%' OR caption LIKE '%person%' OR user1 LIKE '%person%' OR user2 LIKE '%person%' OR user3 LIKE '%person%' OR user4 LIKE '%person%'
[8] => SELECT COUNT(*) FROM cpg132_pictures WHERE ( pid in ('') and pid in ('') ) AND approved = 'YES'
[9] => SELECT * FROM cpg132_pictures WHERE ( pid in ('') and pid in ('') ) AND approved = 'YES' LIMIT 1 ,1
)
==========================
GET :
------------------
Array
(
[album] => search
[cat] => 0
[pos] => 1
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.22-standard
------------------
Coppermine version: 1.3.2
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 4.0.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/johnlat:/usr/lib/php:/usr/local/lib/php:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.057 seconds - 10 queries in 0.001 seconds - Album set :
-
WFM, try clearing your cookies.
-
Thank you Nibbler.
Interesting...I gave this a try and it worked.
-
Sometimes an error message is exactly what it says.
Changing DATA can change the execution of the code, such that you would get different errors or none at all.
You haven't given us a lot to go on. It may NOT be something you added, it may be a problem with the possibility in the code to try to redeclare clean_words depending on some bizaree situation that the devs never thought would happen.
The advice is still sound. You got that error for a reason, if you find out WHY you will be closer to finding out what's going wrong.
The debug code by itself isn't very helpful to be honest with you.
Turn on notices, reproduce the problem, post the contents of the error, the debug output, and all of the notices.
FYI, I did as your first post suggested and I didn't have a problem getting ANY of the photos that came up in the search to come up. Either you've fixed the problem, or maybe its related to your cookies.
-
This is a double post, you were recieving help within your first post, and they both came to the same conclusion.
You are wasting multiple supporters time by doing this.
I'll be merging your posts.
-
I noticed your keywords are things like - , (space) and the like. Keywords are single words separated by spaces. If you have the following keywords:
this - is - really, cool
your keywords are:
this
-
really,
cool
One of your pictures has this for keywords:
Vivian Colleta (Abell) Strawbridge - Clara Harvey - Blanche M - Merta Y unknown - ,
I imagine that is causing your problems, which can lead to bizarre, unexplainable error messages, since one of those rogue characters can interrupt php parsing. I also can't reproduce your error messages.
-
The problem appears to be related to the cookie.
-
so you probably deleted you cookie and the problem was gone, right? Case closed?
Joachim
-
Ya...case closed. I've pretty much decided that the thing to do is to reset the cookie to a new value as admin after every major change. :-\\
-
that shouldn't be necessary, but it won't hurt either. Marking this thread as "solved" then.
Joachim