Critical error: There was an error while processing a database query. Critical error: There was an error while processing a database query.
 

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

Critical error: There was an error while processing a database query.

Started by meloniq, December 04, 2005, 09:24:53 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

meloniq

When my user want upload images, show him bug

Critical error: There was an error while processing a database query.

While executing query "INSERT INTO cpg133_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip)
VALUES ('', '22', 'userpics/10327/', 'luis_royo172~0.jpeg', '31653', '53720', '503', '700', '1133724303', '327', 'o'qlt','luis', '', '', 'YES', '', '', '', '', '80.49.126.130', '80.49.126.130')" on 0

mySQL error: Something is wrong in your syntax obok 'qlt','luis', '', '', 'YES', '', '', '', '', '80.49.126.130', '80' in line 1


I know that it's problem with his login (o'qlt)
If is the other solution, beside change his login? ::)

I greet,
meloniq

Nibbler

include/picmgmt.inc.php, find

$username= USER_NAME;

change to

$username= addslashes(USER_NAME);

meloniq