...

Home
News
Joomla Extensions
Research
Programming
Graphic Design
Me
Forum
Downloads
Gallery
What I Don't Know Wiki
Search
Links
Contact Me
Bibliography
Administrator

Login

Who's Online

We have 1 guest online

Google








Home arrow Programmingarrow Joomla Extensionsarrow DB function failed with error number 1064You have an error in your SQL syntax; c
Discussion Forum
December 04, 2008, 04:49:04 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: SMF - Just Installed!
 
   Home   Help Search Login Register  
Pages: [1]
« previous next »
  Print  
Author Topic: DB function failed with error number 1064You have an error in your SQL syntax; c  (Read 1047 times)
firetext
Newbie
*
Posts: 10


View Profile Email
« on: June 21, 2007, 01:04:59 AM »
Hi Mark

When I enter in a Reference and try and modify any field I get this error after I hit save.

Code:
DB function failed with error number 1064You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the

It it something I'm doing wrong? I installed the latest version .23

Thanks! Let me know
Raoul
Logged
Mark Austin
Administrator
Jr. Member
*****
Posts: 97



View Profile Email
« Reply #1 on: June 21, 2007, 07:33:55 AM »
I thought I had fixed that bug, I will have to try and recreate it and fix it fully.

Mark
Logged
Mark Austin
Administrator
Jr. Member
*****
Posts: 97



View Profile Email
« Reply #2 on: June 22, 2007, 01:56:18 PM »
I have not been able to recreate this bug with the latest version, could you send me a bibtex file containing your references and tell me which field in which reference you edit to get the error.  Also, is it in the back end or the front end.

Thanks
Logged
firetext
Newbie
*
Posts: 10


View Profile Email
« Reply #3 on: June 22, 2007, 04:04:53 PM »
Hi Mark

I get it when I make any change to any of the fields in the front or backend. I'm going to send you a PM with my login and pass. It could be something from my end too.

Raoul
Logged
Mark Austin
Administrator
Jr. Member
*****
Posts: 97



View Profile Email
« Reply #4 on: June 23, 2007, 09:24:39 AM »
Good news, I have located the bug. The apostrophes in your fields, i.e. the abstract field for one and the title field for another, cause the sql strings to mess up.  I will need to write a fix for this as soon as I can, however for now, if you take out the apostrophes in your abstracts (I have already done so), the problem will go away.

Mark
Logged
firetext
Newbie
*
Posts: 10


View Profile Email
« Reply #5 on: June 30, 2007, 08:32:24 PM »
Hi Mark!

I have this issue still, but this time I don't get an error message. What happens when I make an edit and save it is that it reverts back to the original document without saving any changes.

Keep me posted!
Raoul
Logged
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by SMF 1.1.1 | SMF © 2006, Simple Machines LLC
Joomla Bridge by JoomlaHacks.com
© 2008 Everything That I Know About