a lot of mysql error why ?

[hendri]

just upgraded from 5.62 to 6 then 6.01

then i got a lot emails said that mysql command error :

---------------------------------------------------
An error was encountered during execution of the query:

SELECT watermark,ugnoanno FROM pp_categories where id=

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

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

------------------

An error was encountered during execution of the query:

INSERT INTO pp_photos (id,user,userid,cat,date,title,description,ismature,keywords,bigimage,width,height,filesize,medwidth,medheight,medsize,approved,lastpost,
watermarked,allowprint,extra1,extra2,extra3,extra4,extra5,extra6,ipaddress,allowrate,allowcoms)
values(NULL,'ratel', 407, , 1194174985, 'VIP Red', '', 0, '', 'PA270615A.JPG', 800, 600, 74337,
800, 600, 182107, 1, 1194174985, 'yes','yes','','','','','','','202.156.9.4','1','1')

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 ' 1194174985, 'VIP Red', '', 0, '', 'PA270615A.JPG', 800, 600, 74337,
800' at line 3

If you need assistence or feel this is a 'bug'; please report it to our support forums at: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

----------



anything can do to fix this ?

[Chuck S]

If you turn off your vb integration does this happen anymore?

my response in your other thread points to your queries are being altered in someway to input data in the wrong order in queries which does not happen in a normal integration so lets see if you disable your integration and see if things work fine. If they do then we can start narrowing things down to turning integration on but disable all your vb hacks and see if things still work. If thats the case then in the end run you need to enable hacks one by one till we find the one that is causing an issue.

[hendri]

i use vb version 3.6.5 , is that not compatible with the newest version of photopost ?

[Chuck S]

No what I am saying is your errors are strange like something is messing with the order in which data is being formatted for the query.

This error is different that your other thread as the issue is your category is empty and my question is why would it be empty ever. If you turn off your vb3 integration and do the same actions your doing to get the errors when vb3 integration is on and they dont happen with vb3 integration off that tells me you have some hack installed that causes this then we go on to the next step and try and diagnose things by turning on vb integration and turning all hacks off and see if things work. If that works then you turn on hacks one at a time to discover which hack causes this issue.

I hope this clarifies the order in which to diagnose what the issue might be.

[hendri]

i try upload again all the photopost files..

so far so good...

the error is from members not from me.

thanks

[Chuck S]

Right but how about what I asked. Have you done as instructed and what is the result? Do you allow unregistered uploads?