Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo
I was trying to create an iframe using show.php to add a list of scientific papers to my website. However, during the process I think I must have changed something as now show.php is not working at all!
It is coming up with the following error:
SELECT serial, author, title, year, publication, , thesis, orig_record, serial, file, url, doi, isbn, type FROM refs WHERE created_date = "2011-01-28" ORDER BY author, year DESC, publication
caused the following error:
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 ' thesis, orig_record, serial, file, url, doi, isbn, type FROM refs WHERE created' at line 1
The error seems to be by the additional comma next to thesis, but that is as far as my knowledge has got me! I have tried replacing the show.php file with the original copy downloaded (incase I had managed to alter the file somehow) but that has not fixed the problem.
Any help would be greatly appreciated.
Do direct calls to show.php work? Could you have changed another script that is called by show.php?
Thank you for your help, and sorry for the slow reply. I am not sure how to call show.php directly. However, I went through each file that I had changed individually and replaced them with the original version of the file until I found the problem. It was the ini.inc.php file. As soon as I fixed that it corrected the error I was seeing.
Glad that it now works. show.php is documented at http://www.refbase.net/index.php/Linking_to_records