Register    Login    Forum    Search    FAQ

Board index » Bugs » Bugs happen!




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: My Links
 Post Posted: Sun Jan 22, 2012 3:20 pm 
Offline

Joined: Sun Jan 22, 2012 3:15 pm
Posts: 2
I received an error when i tried to add a 3rd web link - I have been logged in an idle for hours....(btw - I would think that my login would time out.) I am new, HOURS. I am server, network and app kind of guy, not accountant/ERP guy... here is the error log...

Code:
race information for debug purposes. Phreedom release 3.3, generated 2012-01-22 16:02:16.


GET Vars = Array ( [module] => phreedom [page] => main [mID] => index )
POST Vars = Array ( [personal_links_field_0] => Midway's Home Page [personal_links_field_1] => http://www.midwayumc.net [sub_personal_links] => Add [personal_links_rId] =>  [dashboard_id] => personal_links [column_id] => 2 [row_id] => 2 [todo] => save )
Time: 64 ms, 3 SQLs 2 ms =>
The failing sql was: update users_profiles set params = 'a:3:{s:18:"Midway's Home Page";s:24:"http://www.midwayumc.net";s:6:"Search";s:21:"http://www.google.com";s:4:"news";s:22:"http://news.google.com";}'
     where user_id = 1 and menu_id = 'index'
      and dashboard_id = 'personal_links'
Time: 65 ms, 3 SQLs 2 ms =>
mySQL returned: 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 Home Page";s:24:"http://www.midwayumc.net";s:6:"Search";s:21:"http://www.googl' at line 1

Page trace stats: Execution Time: 65 ms, 3 queries taking 2 ms


Top 
 Profile  
 
 Post subject: Re: My Links
 Post Posted: Mon Jan 23, 2012 4:22 am 
Offline

Joined: Mon Mar 01, 2010 5:32 am
Posts: 554
Location: Netherlands
The problem is the single quote in Midway's.
if you remove it your problem is bypassed.

_________________
Rene Kervezee


Top 
 Profile  
 
 Post subject: Re: My Links
 Post Posted: Mon Jan 23, 2012 9:57 am 
Offline

Joined: Sun Jan 22, 2012 3:15 pm
Posts: 2
DUH - Thanks for that.... I am not going to try and cover-up stupid. Too make this worst, I had tried to enter another Link and named it Mike's Site ....Well we now know what the ' getz ya! So, I am thinking something just broke and moved on to trying to learn ACCOUNTING to know if this installation is working correctly!! THANKS FOR THE HELP! D@mn this is GREAT software...If the ladies at church like it...we will make a change and do some donating to an excellent effort!!!!! ReneK THX AGAIN!


Top 
 Profile  
 
 Post subject: Re: My Links
 Post Posted: Tue Jan 31, 2012 12:59 pm 
Offline

Joined: Mon Mar 01, 2010 5:32 am
Posts: 554
Location: Netherlands
I remember that i wrote a dashboard for displaying the websites of contacts.
it is named 'Contacts Website Dashboard' and can be found on the main website.

and this dashboard does not care if you use quotes.

_________________
Rene Kervezee


Top 
 Profile  
 
 Post subject: Re: My Links
 Post Posted: Wed Feb 01, 2012 9:50 pm 
Offline

Joined: Fri Oct 26, 2007 3:55 pm
Posts: 3499
Location: Colorado, US
This is an underlying problem that I have to fix. I was a bit sloppy when inserting data and updating data in the db. I should have built an associative array and use the db_perform function. This adds slashes to the fields and prevents this problem. I have sporadically fixed these as bugs are posted but I have on my list to fix all cases for future releases. Sorry for the problem the code should have been able to handle the single quote.

Dave


Top 
 Profile  
 
Display posts from previous:  Sort by  
 
Post new topic Reply to topic  [ 5 posts ] 

Board index » Bugs » Bugs happen!


Who is online

Users browsing this forum: No registered users and 0 guests

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: