MySQL Error Report

mjm · December 19th, 2006, 02:42 PM

We just got a couple of these and curious what it means.
I can't find any problems at the gallery.
Thanks,
Mark
------------

An error was encountered during execution of the query:

SELECT id,user,userid,date,bigimage,cat,storecat,rating,title,description FROM plphotos WHERE id IN () LIMIT 0

The query returned with an errorcode of:

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 ') LIMIT 0' at line 1

Chuck S · December 19th, 2006, 03:31 PM

well the error is because $idlist is empty I would guess need to know how this is happening to suggest something.

mjm · December 21st, 2006, 01:52 PM

We got a couple more of these today.
None one has posted of a problem at our site so I don't know how to trace it if it is a problem.
It's been the longest time since we have had any errors and as this only happened after upgrading one of our galleries to 3.62, is why I posted it.

We'll see if it persists or increases after upgrading our other galleries this weekend.

Michael P · December 21st, 2006, 06:53 PM

Someone is looking for a searchid that exists but has no results (which is unusual); not sure I understand why, but you can clean up this message with the couple lines at line 99 in search.php:

Code:

Content visible to verified customers only.

It could be a paging issue, but not sure without more specifics.

mjm · December 30th, 2006, 04:47 AM

We didn't apply the above as I soon found that the search wasn't functioning and waited till we applied the latest 5.62 build.

We have upgraded now, but even though we are not receiving any error messages it shows:
No photos found. If you searched, try fewer or less specific keywords.

Maybe this is a installation issue and not a bug. We're stumped.

Chuck S · December 30th, 2006, 08:10 AM

maybe an install issue why not download the build and use the default files

Michael P · December 30th, 2006, 08:16 AM

Using the searchid, check the searchid table to see if there are results for the search stored in the table.

Carolem · December 30th, 2006, 12:25 PM

Quote:

Originally Posted by Michael P

Using the searchid, check the searchid table to see if there are results for the search stored in the table.

Yes, I checked in pma and there are lots of numbers in the idlist column of the searchid table.

Carolem

Carolem · December 30th, 2006, 08:25 PM

(trying to trouble shoot our search non functioning

When searching in the search.php file for the phrase which was in our original error message:

SELECT id,user,userid,date,bigimage,cat,storecat,rating,title,description

it takes me to line 106.

Could something in or near that line have something to do with the search function not working properly?

Carolem · December 30th, 2006, 09:07 PM

I tried uploading all new files and the search still did not work.

We just get this message:

Quote:

No photos found. If you searched, try fewer or less specific keywords.

Chuck S · December 30th, 2006, 09:27 PM

Carole

Please try using unmodified stock 5.62 files. I am not seeing any issues with the downloadable source files.

I know you guys like to modify things but it would appear this time your issue is with the mods to your search file.

Carolem · December 31st, 2006, 12:38 AM

Thanks Chuck,
I loaded up the straight unedited files again, but still got the same results.
baffled,
Carole

Chuck S · December 31st, 2006, 06:17 AM

Have you can the upgrade scripts for 5.5 and 5.6?

Are ALL YOUR FILES clean unmodified files?

Carolem · December 31st, 2006, 07:38 AM

Yes, all the files were unmodified and the results were the same.
(I did put my modified files back for now - since the result was the same modified or not.)

I did do the upgrade script when I upgraded. (I have the new searchid table)

Can I run the upgrade script again?

Carole

Chuck S · December 31st, 2006, 08:19 AM

You can run those upgrades again. You are telling me this is a completely unmodified Photopost now for me to test?

All core php files and templates?

Carolem · December 31st, 2006, 08:29 AM

I will not be able to do anything and put the default files back in till this evening.
Carole

Carolem · December 31st, 2006, 07:38 PM

I re-ran the upgrade script and have all default files in right now.
The search function still does not work.

I got this message when I ran the upgrade script:
Preparing to update database...

Error performing MySQL command: ALTER TABLE plusers ADD lastphoto INT( 12 ) NOT NULL DEFAULT '0', ADD lastdate INT( 15 ) NOT NULL DEFAULT '0'
Error: Duplicate column name 'lastphoto'

Error performing MySQL command: CREATE TABLE plsearchids ( searchid INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , userid INT( 12 ) NOT NULL DEFAULT '0', searchtype VARCHAR( 1 ) NULL , searchterms VARCHAR( 250 ) NULL , searchdate VARCHAR( 5 ) NULL , cats MEDIUMTEXT NULL , name VARCHAR( 64 ) NULL , preview SMALLINT( 1 ) NOT NULL DEFAULT '1', idlist MEDIUMTEXT NULL , numresults INT( 5 ) NOT NULL DEFAULT '0', ipaddress VARCHAR( 15 ) NULL , searchtime FLOAT( 6, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: Table 'plsearchids' already exists

Error performing MySQL command: INSERT INTO plsettings VALUES (221,'Require users to be registered to use search?','searchreg','','no',1,14)
Error: Duplicate entry '221' for key 1

Error performing MySQL command: INSERT INTO plsettings VALUES (222,'Maximium number of search results to return?','searchmax','On larger sites, the less the better.','500',2,14)
Error: Duplicate entry '222' for key 1

Error performing MySQL command: INSERT INTO plsettings VALUES (223,'Number of seconds between searches?','searchto','The number of seconds a user must wait between searches.','30',3,14)
Error: Duplicate entry '223' for key 1

Error performing MySQL command: INSERT INTO plsettings VALUES (224,'Number of days to hold search results?','searchhold','','7',5,14)
Error: Duplicate entry '224' for key 1

Error performing MySQL command: INSERT INTO plsettings VALUES (225,'Display who is viewing a category?','catonline','This option adds a query to the Show Gallery page.','yes',5,4)
Error: Duplicate entry '225' for key 1

Upgrade complete! You should continue to next step

Carolem · December 31st, 2006, 08:26 PM

Chuck - it is New Years Eve, so I don't expect you to have time this evening to check it out so I am putting our modified files back in-

Please let me know when you can check it out and I will reload the default files

Here's a toast to photopost!
Have a Happy New Year

Carole and Mark

Chuck S · December 31st, 2006, 08:51 PM

shoot me over ftp and admin access and I can upload clean files tomorow and test it out

mjm · January 1st, 2007, 11:32 AM

Thanks Chuck! Carole's sent you the info.
It's odd that in phpMyAdmin > searchids > idlists that it does show that photos are found though search results says no photos found.

One difference I've seen is in our advanced search, it shows ...
Specify a date range
Within the last 1

Whereas at PhotoPost gallery it doesn't show the 1

Changing this in the search made no difference.