![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| I'm new to MySQL. Sorry for asking for some probably very basic help. The following code is from a Dump of a php forums database (openBB software, now discontinued). It was installed on a server running MySQL 4.0.18 ================================================== ====== -- MySQL dump 9.11 -- -- Host: localhost Database: Apxxxxxxxxxx -- ------------------------------------------------------ -- Server version 4.0.18 -- -- Table structure for table `ap_active` -- CREATE TABLE ap_active ( member varchar(50) NOT NULL default '', lastaction int(10) NOT NULL default '0', record varchar(32) NOT NULL default '', ip varchar(15) NOT NULL default '0', location varchar(100) NOT NULL default '', invisible enum('1','0') NOT NULL default '0', inforum int(4) NOT NULL default '0', KEY member (member), KEY inforum (inforum) ) TYPE=MyISAM; -- -- Dumping data for table `ap_active` --. ...... etc ================================================== ====== When trying to restore the base, I get: .................................................. .............................. MySQL said: #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 'CREATE TABLE ap_active ( member varchar(50) NOT NULL default ' .................................................. .............................. On my system: -MySQL is version 4.1.9 -phpMyAdmin is 2.6.1 (Apache 1.3.33 and php 4.3.10, just for information) What is wrong? I can't figure it out, sorry, I'm new to SQL and I only found a MySQL 5 manual online so far. | |||
|
| Featured Websites | ||||
|
![]() |
| Tags: error, help, syntax |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Syntax error? | Joneleth | Database | 2 | 07-01-2007 7:01 PM |
| Mysql Syntax error | Jeffrey Ellis | PHP | 2 | 07-01-2007 5:11 PM |
| Syntax Error: Newbie Help | Venture Zone | PHP | 0 | 07-01-2007 3:32 PM |
| cursor : where is my syntax error ? | jahjah92 | Database | 0 | 06-26-2007 12:08 AM |
| amazing syntax error | Oli Filth | Database | 0 | 06-10-2007 12:18 AM |
| Featured Websites | ||||
|