MySQL Syntax Error

New Member Joined: Aug 20, 2006 Posts: 4

I am having a problem with the MySQL Table Installer. Everything works fine up to Step 4. I’ve tried doing Steps 4a-4f, but only step 4d loads properly. With the other steps I get error messages like:

ERROR! The exact error message that your MySQL server reported is 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 ''Philippines')' at line 1.

I admit I am a total noob at SQL and PHP. I have had very limited experience installing PHP applications. If I’m not mistaken, I’ve listed the SQL for the particular error message listed above at the end of my post. If I’ve done the noob thing and posted the wrong info, please let me know. I’d really like to give RavenNuke a try.

The other error message I get is:

ERROR! The exact error message that your MySQL server reported is Duplicate entry '1072932352-1072932863' for key 1. (I was unable to locate the SQL for this error message. If you can tell me where to look for it in phpMyAdmin I will try to find it.)

In case it helps, the “cpanel build” my web host uses is 10.8.1-STABLE 114, the PHP version is 4.4.2, the operating system is Linux, the Apache version is 1.3.34 (Unix), and the MySQL version is 4.0.27-standard.

SQL:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 20, 2006 at 09:44 AM
-- Server version: 4.0.27
-- PHP Version: 4.3.11
--
-- Database: `alzirr_nuke1`
--

-- --------------------------------------------------------

--
-- Table structure for table `nuke_nsnst_ip2country`
--

CREATE TABLE `nuke_nsnst_ip2country` (
`ip_lo` int(10) unsigned NOT NULL default '0',
`ip_hi` int(10) unsigned NOT NULL default '0',
`date` int(20) NOT NULL default '0',
`c2c` char(2) NOT NULL default '',
`country` varchar(60) NOT NULL default '',
PRIMARY KEY (`ip_lo`,`ip_hi`),
KEY `c2c` (`c2c`),
KEY `date` (`date`)
) TYPE=MyISAM;

--
-- Dumping data for table `nuke_nsnst_ip2country`
--

INSERT INTO `nuke_nsnst_ip2country` VALUES (1072938496, 1072938751, 1109653200, 'ph', 'Philippines');

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

Sounds like you are trying to load the same data twice. Try dropping the table (execute this SQL in phpMyAdmin: drop table nuke_nsnst_ip2country ), then execute the SQL again.

Posted: Sun Aug 20, 2006 9:56 pm

Thanks for the reply. I dropped the table and now I get this error message:

ERROR! The exact error message that your MySQL server reported is Table 'alzirr_nuke1.nuke_nsnst_ip2country' doesn't exist.

Any help is appreciated.

edit:

I tried running from step 1 also, then going into the ip2country table and dropping all the individual country tables then running step 4 again (only clicking once). It appears that the installer is making multiple entries for most (perhaps all) of the country tables, like Germany, Italy, Phillipines, etc. I don't know if this is intended or if there is only supposed to be one entry for each country.

registered · Posted: Thu Aug 24, 2006 12:41 pm

There are multiple entries for all the different ranges of a country. Don't worry about - it is intended.

Posted: Thu Aug 24, 2006 11:09 pm

Well I figured out what the problem was with it. Somehow I ended up with an older version of the RavenNuke. I downloaded and installed the latest version and everything seems to work great now except that I cannot log in as admin.

I have searched the forums and tried the suggested fixes I've found, but am having no luck so far. Even though my user name and pass are in the MySQL table, the site will not let me log in as admin. I'm getting closer! Any help on this issue would be appreciated. Thanks.

Posted: Fri Aug 25, 2006 6:27 am

To log in as an admin you need to log in via the url www.yoursite.com/admin.php

If you are logging in through that url and it wont let you, try clearing your cookies.

If clearing the cookies fails, does your normal user account log in work?

If your normal user log-in works, via phpmyadmin copy the password from the password field in the table nuke_users for your account name and then paste it into the password field for your admin account in the table nuke_authors - this will ensure its not an incorrect password.

Posted: Fri Aug 25, 2006 1:44 pm

I had to set the password again for nuke_authors, but once I did that I was able to log in just fine through the admin.php page. My regular user account works for the normal login too.

Thanks to everyone for the help. It is most appreciated. Smile

Posted: Sat Aug 26, 2006 12:29 am

No problem, thank you for taking the time to let us know your problem is resolved.