[Solved]: Picture comment error [Solved]: Picture comment error
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

[Solved]: Picture comment error

Started by Hot Rides, April 19, 2008, 08:34:08 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Hot Rides

Get an error when leaving a picture comment.

~~~~~~~~~
While executing query "SELECT *,  AS auto_subscribe_comment FROM `dodgeste_smf1`.smf_members WHERE ID_MEMBER = '1'" on Resource id #27

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 'AS auto_subscribe_comment FROM `dodgeste_smf1`.smf_members WHERE ID_MEMBER = '1'' at line 1
~~~~~~~~~

Any idea where I should start looking to fix? or has anyone seen this before?

site= www.hot-rides.net/coppermine
user= testuser
password= testpassword

Thanks in advance for the help

Stramm

have you uploaded all modpack files properly (especially bridge/smf10.inc.php)

Hot Rides

Quote from: Stramm on April 20, 2008, 01:03:31 PM
have you uploaded all modpack files properly (especially bridge/smf10.inc.php)
I have been editing on smf10.inc.php
I will double check to see it ifts the modpack version, but I dont see how my code could effect this
I also noticed, Im geting the same error when uploading a picture now.

Hot Rides

Quote from: Hot Rides on April 21, 2008, 12:26:19 PM
I have been editing on smf10.inc.php
I will double check to see it ifts the modpack version, but I dont see how my code could effect this
I also noticed, Im geting the same error when uploading a picture now.
Ok, did that, now Im getting an album doesnt exsist error

Stramm


Hot Rides

ok, im glad the comments are working now, any idea why im having trouble uploading?

Hot Rides

Quote from: Hot Rides on April 21, 2008, 01:27:31 PM
ok, im glad the comments are working now, any idea why im having trouble uploading?
nevermind, its fixed
http://coppermine.svn.sourceforge.net/viewvc/coppermine/trunk/cpg1.4.x/db_input.php?r1=3338&r2=3364
was the problem, forgot I had done that when I upgrade to the latest version.

matter is solved