Saved Bookmarks
| 1. |
Solve : having a lil error SQL Error : 1064? |
|
Answer» 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 ' 'Styles')' at line 1 INSERT INTO nuke_bbadmin_nav_module (user_id, modulname) VALUES (, 'Styles') Line : 86 File : /home/worsqua/public_html/modules/Forums/admin/index.php now i go into tge sql admin and i go to nuke_bbadmin_nav_module then i guess i go to insert but i dont know what to do form there can anyone direct me pleaseBetter SQL would be: INSERT INTO nuke_bbadmin_nav_module (user_id, modulname) VALUES ('', 'Styles'); or INSERT INTO nuke_bbadmin_nav_module (user_id, modulname) VALUES (NULL, 'Styles'); Later VERSIONS of MySQL are stricter about this.umm thats not telling me much can u tell me how to inset thoughsHe's saying that where you normally type INSERT INTO nuke_bbadmin_nav_module (user_id, modulname) VALUES (, 'Styles') you should type one of those two he mentioned. Let me just hypothesise, since you didn't tell us what you're try to do: have you installed phpnukebb or something like that? Are you trying to run it with the very latest version of MySQL? Have you checked whether it's compatible? Many things change between MySQL versions, and the developers of phpnuke may not have brought the software fully up to date as yet. You can find the file referred to, go to line 86, and correct the error. Or you can downgrade to an earlier MySQL - the one that phpnuke is designed for.yes the phpnuke is installed on the server it all works fine except when i go into the forums admin SECTION it gives me this error in the catagorie BOXS on the left if you know what im talking about ok maybe this will help ask my question i put (exzactly what) into (what on there) lolCan you not just correct the error in the /home/worsqua/public_html/modules/Forums/admin/index.php file? (See my first post.)83/ $no_page_header = TRUE; 84/ 85/ $phpbb_root_path = "./../"; 86/ 87/ REQUIRE('./../extension.inc'); 88/ 89/ require('./pagestart.' . $phpEx); i dont see nothing wrong :S Perhaps you should report this as a bug to the designers of the phpnuke software you're using? In the meantime, you can turn off the strict ANSI mode in your my.cnf file. Can't remember what the setting is called; you'll have to search for it in the file. |
|