Frequently Asked Questions SQL Error When Logged In ( FAQ )

Worker Joined: Aug 22, 2006 Posts: 192

Hi everyone,

(With much assistance from Raven), I have just installed a brand new site using the new (2.20.00) version of Raven Nuke.

I have activated the FAQ (Frequently Asked Questions) Module, but as yet no posts have been made to this module.

I notice that when I am not logged in (as a user), I am able to click the link and view the module. However, when I do log in to my user account and click the link, I cannot view the module. Instead I receive a white page with the following error/text:

Unable to Insert MySQL said: 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')' at line 1

While this is not a major concern to me immediately, I wonder if anyone else has seen or is experiencing the same issue?

Thanks in advance as ever.

Posted: Wed Feb 20, 2008 9:25 pm

If you look in rnconfig.php there is an option to activate database. If you follow the instructions to do this you should be able to view the actual MYSQL error in /rnlogs/dblog. I know you posted the mysql error but the log will also show the actual SQL that generated that error. If you post it here we might be able to help.

I suspect that the FAQ module has not been extensively tested and you might be encountering a "legacy" error.

registered · Posted: Wed Feb 20, 2008 10:31 pm

I have several FAQ's on my site and they all seem to work fine. However these have been drug along with my site ever since I was running 7.9. So my path was upgrade, not fresh install. Yeah, turn on that logging it will pinpoint it for us.

Posted: Thu Feb 21, 2008 7:03 am

I don´t get such an error on any of my sites.

Posted: Thu Feb 21, 2008 8:59 am

Weird, emmaphp sent me a log but it didn't contain any errors, let alone any FAQ table manipulations.

Posted: Thu Feb 21, 2008 12:11 pm

Sorry, I am not getting any error either.
Did you create a category through the nuke admin / FAQ interface? As I notice there is none by default

Posted: Thu Feb 21, 2008 12:50 pm

I take that back, his log had an error about a nuke_email_config table. This isn't in stock RavenNuke is it? I don't have that table.

Posted: Thu Feb 21, 2008 12:54 pm

I believe that the mail config table gets created when you go into Mail administration in the ACP. So that error will be there until you do. I haven't had time to confirm this but I'm pretty sure that's how it works.

Posted: Thu Feb 21, 2008 4:17 pm

Hi Everyone,

Thanks for your continued feedback with this matter.

To clarify Guardian2003, I created a test FAQ catagory and q & a in the following way:

1. I went to the website admin section at www.MYDOMAIN.com/admin.php, clicking on FAQ,

2. In the Modules Administration area, I clicked on the FAQ link/icon

3. In the filed under the title 'Add a New Category' I created a catagory

I hope that helps.

Please can someone explain what ACP stands for and if I can do anything to/with this to try and resolve the problem?

What else can I do to help solve this matter?

Posted: Thu Feb 21, 2008 4:21 pm

I don't understand what the FAQ module would be trying to insert into the database just by visiting it. I'll look at the code to see if I see any INSERTs in the user part of the FAQ module.

But I think at this point if you can get access to your server error logs that would be very helpful.

ACP stands for Admin Control Panel.

Posted: Thu Feb 21, 2008 4:42 pm

Hi Gremmie,

Which log file do you want to see?

To clarify, in addition to any raven nuke logs that may be generated, (and if you mean these you will have to tell me specifically which file you require), my server gives a file called access.log or scripts.log

To the best of my knowledge and from what I can see, no error is being generated in the scripts.log file.

Please advise further.

Posted: Thu Feb 21, 2008 4:45 pm

It would be nice to see your server error logs. What they are called exactly and how you get to them are host specific. Ask your host if you have access to them. If your host gives you a Plesk control panel, there is Logs icon that you click to access the server logs.

Posted: Thu Feb 21, 2008 5:35 pm

humm ... just wondering if this could be a situation where MYSQL 5 is being more "strict" than 4 was ...

I am trying to get my test system updated so I can try a few things there too.

For instance the faqcategories table has this definition:

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_faqcategories` ( `id_cat` tinyint(3) NOT NULL auto_increment, `categories` varchar(255) default NULL, `flanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`id_cat`) ) TYPE=MyISAM;

Yet in the faq admin program we do this:

Code:

$db->sql_query("insert into ".$prefix."_faqcategories values (NULL, '$categories', '$flanguage')");

I vaguely recall coming across some circumstances where MYSQL 5 wouldn't tolerate this where 4 would. But I'm not sure.

Posted: Thu Feb 21, 2008 6:25 pm

I seem to recall Raven having to modify emmaphp's require statement in mainfile.php to be require_once('/config.php');

He's getting a similar error in config.php about trying to find 'rnconfig.php'. I just asked emmaphp to change that to '/rnconfig.php'. He's getting an error in his server logs about config.php not being able to open rnconfig.php. Why that is only happening on the FAQ module is beyond me.

Regular Joined: Mar 14, 2005 Posts: 91

Looking at this code...

Code:

CREATE TABLE IF NOT EXISTS $prefix.`_faqcategories` ( `id_cat` tinyint(3) NOT NULL auto_increment, `categories` varchar(255) default NULL, `flanguage` varchar(30) NOT NULL default '', PRIMARY KEY  (`id_cat`) ) TYPE=MyISAM;

I think TYPE=MyISAM should be changed to ENGINE=MyISAM for newer versions of mysql. Also, the the ` are in the wrong place.

The above has:

Code:

$prefix.`_faqcategories`

Which ends up as nuke`_faqcategories` Wink

Posted: Thu Feb 21, 2008 7:07 pm

There is no code in modules/FAQ/index.php that executes an INSERT SQL statement. That error must be coming from some infrastructure code in mainfile.php or modules.php.

Posted: Thu Feb 21, 2008 7:09 pm

gotcha, where did you get that code? If you got it where I think you did, that code is preprocessed before executed, so don't worry about the $prefix and the quotes being out of place. Also, TYPE is still valid under MySQL 5.0 for backwards compatibility.

Posted: Thu Feb 21, 2008 7:09 pm

Hi again all,

I am not too sure where the code Gotchas previous post refers to is located and I will wait for someone to advise further before attempting to make any changes.

In the meantime, if it helps, I can confirm that my system is running MySQL 4.1.14

Also, in his last post I think Gremmie was slightly incorrect in understanding what change I had to make with a previous issue I was having. So for this reason I will hold off making a move on this advise, (just in case he did slightly misunderstand etc). On this point, to clarify, Raven had to make a change in my config.php which was as follows:

Change:

require_once('rnconfig.php');

TO:

require_once('/rnconfig.php')

This did not involve any changes to the mainfile.php file as suggested by Gremmie, so I will not act on his last post until advised otherwise, (i.e if he made an error or not)

Thanks for all your help guys and gals.

Posted: Thu Feb 21, 2008 7:15 pm

Well in that case emmaphp, are the errors in your server error logs regarding not being able to open rnconfig.php from today? I suspect those errors were from before Raven made his change. If that is the case, disregard my advice. Someones going to have to look at your system to figure this one out.

Posted: Thu Feb 21, 2008 7:20 pm

Gremmie wrote:

There is no code in modules/FAQ/index.php that executes an INSERT SQL statement. That error must be coming from some infrastructure code in mainfile.php or modules.php.

Gremmie,

Which error do you refer to in your post, (quoted above here)?

If you mean the error I originally reported myself, ie:

Unable to Insert MySQL said: 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')' at line 1

...Well that error appears on a white page in my browser, when I am logged in (as a user) and after I click the FAQ link in the modules block.

I hope this helps.

Posted: Thu Feb 21, 2008 7:22 pm

Gremmie wrote:

Well in that case emmaphp, are the errors in your server error logs regarding not being able to open rnconfig.php from today? I suspect those errors were from before Raven made his change. If that is the case, disregard my advice. Someones going to have to look at your system to figure this one out.

Yes Gremmie...The error ('code') I see currently in the log file and which I sent you a copy of, appear to be from previous dates and the previous issues I was having.

As I said in the Private Messages, I do not think any error log is being generated for this particular 'faq' problem.

Even when I switch the config.php file to 'true' for reporting errors, nothing is reported on the screen other than the original text I have quoted in my last post here.

Posted: Thu Feb 21, 2008 7:38 pm

Gremmie, that code came from fkelly's post above mine. I just noticed that the backticks looked out of order, I didn't know exactly where the code fkelly posted came from. Looking back, I should have known that the sql would be parsed in some way Laughing

Posted: Thu Feb 21, 2008 7:53 pm

gotcha, well....gotcha! Smile

Yeah that came from the install script.

emmaphp, this is a stumper. I can't replicate this on my site, either my production site or my local XAMPP install. Do you have any 3rd party modules or blocks that you installed? The only thing I can think of is that you do, and they are not use the $db abstraction layer. That is the only reason I can think of that an INSERT SQL error isn't showing up in the new logging facility.

If you have such blocks/modules, try disabling them in the ACP and see if that changes the behavior.

Posted: Thu Feb 21, 2008 7:56 pm

Hi Gremmie,

All I have installed in my system/website is the new version of Raven Nuke (2.20.00)

Sad

Posted: Thu Feb 21, 2008 8:44 pm

What version of MySQL are you running?