Icy Phoenix

     
 


This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post FAP SUPPORT - Bug When Trying To Edit A Photo Title After It's Posted. 
 
I could not edit a photo after it was posted, here is what I got.
Any ideas to correct the problem?
Thanks


Could not update pic information

DEBUG MODE

SQL Error : 1064 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 '1959 Cab During Restoration - 002', pic_desc= '' WHERE pic_i

UPDATE phpbb_album SET pic_title = 'My '1959 Cab During Restoration - 002', pic_desc= '' WHERE pic_id = '9'

Line : 188
File : album_edit.php
 



 
losthillsguySend private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Bug When Trying To Edit A Photo Title After It's Posted. 
 
It is a wrong escaped SQL...

Can you try to edit that SQL in this way please?

Code: [Download] [Hide] [Select]
    $sql = "UPDATE ". ALBUM_TABLE ."
            SET pic_title = '" . $pic_title . "', pic_desc= '" . $pic_desc . "'
            WHERE pic_id = '" . $pic_id . "'";


If it doesn't work we need to add "ADDSLASHES" function...

Which version of FAP do you have?
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Bug When Trying To Edit A Photo Title After It's Posted. 
 
using  FAP 1.4.1, is this the latest version?

I made the edit,  sometimes it works and sometimes it doesn't.    Here is the debug message after the edit.

Could not update pic information

DEBUG MODE

SQL Error : 1064 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 's 550 Spyder Bike with Fat Boy tires - 004', pic_desc= ''

UPDATE phpbb_album SET pic_title = 'Mark's 550 Spyder Bike with Fat Boy tires - 004', pic_desc= '' WHERE pic_id = '44'

Line : 188
File : album_edit.php
 



 
losthillsguySend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Bug When Trying To Edit A Photo Title After It's Posted. 
 
Seems to be working.  I only got the debug message once.
 



 
losthillsguySend private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Bug When Trying To Edit A Photo Title After It's Posted. 
 
It is related to single quote...

It is strange that on some server it still doesn't work.

Anyway let me know if you are still having problems.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
This forum is locked: you cannot post, reply or edit topics.  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron