help plz

Hotrod · 05-17-2005, 05:24 PM

I just installed the latest version of vBulletin (3.0.7) and I tried to add a back up from my old vBulletin version (3.0.5) when i uplloaded the back up it said the following.

Quote:

CREATE TABLE `access` (
`userid` int( 10 ) unsigned NOT NULL default '0',
`forumid` smallint( 5 ) unsigned NOT NULL default '0',
`accessmask` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `userid` , `forumid` ) --
-- Dumping data for table `access`
--
/*!40000 ALTER TABLE `access` LOCK TABLES `access` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `access` ENABLE KEYS */

and at the bottom of the page it said

Quote:

MySQL said: Documentation
#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 'ALTER TABLE `access`
LOCK TABLES `access` WRITE;
UNLOCK TABL

waht do you guys sugjest i do. if i cant upload it, the whole site will need to start over and we will lose all of are posts, forums and memebrs.

then i deletede all the () and it says

Quote:

SQL-query:

CREATE TABLE `access` (
`userid` int( 10 ) unsigned NOT NULL default '0',
`forumid` smallint( 5 ) unsigned NOT NULL default '0',
`accessmask` smallint( 5 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `userid` , `forumid` ) --
-- Dumping data for table `access`
--
/*!40000 ALTER TABLE `access` LOCK TABLES `access` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `access` ENABLE KEYS */

MySQL said: Documentation
#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 'ALTER TABLE `access`
LOCK TABLES `access` WRITE;
UNLOCK TABL

EDIT" is it the version od phpMyAdmin?

ninedogger · 05-17-2005, 06:17 PM

Quote:

Originally Posted by Hotrod

I just installed the latest version of vBulletin (3.0.7) and I tried to add a back up from my old vBulletin version (3.0.5) when i uplloaded the back up it said the following.

and at the bottom of the page it said

waht do you guys sugjest i do. if i cant upload it, the whole site will need to start over and we will lose all of are posts, forums and memebrs.

then i deletede all the () and it says

EDIT" is it the version od phpMyAdmin?

Maybe it has to do with latest install uses diffren't table names/added more?

Hotrod · 05-17-2005, 06:21 PM

3.0.7 doesnt have vb3_ infront of each table.

3.0.5 does have vb3_

and i even earased the vb3_ parts.

and i even tried to install it onto an empty DB and it still had errors

now its starting to say my version is dif.

My version is phpMyAdmin 2.6.1

and the one in got the back up from is

phpMyAdmin 2.6.1 pl2

now it says:

Code:

There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNqdks1um0AUhffzFGcRKY4EmCEmjkfqgjrIsQrYBZIq3dRjM6lR+XGZIY6fLYs8Ul+hM26dbtsi
gdC599zvntGEabpIGaYUUw9RmDBQePDHI5LlWn8hZHqfMZzNCwb5vdrxTorOqcq1s9vurCd4jjeG
57qjIaVD14frshFlvo9K1BOEzzuckfiQfYwYRo7reJe2VLwpeFeQuyzFIrMQzMIkt3Afat6nskG8
+DyPogC+45JlHDDNuHIoWd4uTY+1yMyoS4dSRGXTP5MoSGYMorFL2drX1/7EpuQI/PHyatvQe8aH
oKj1ZK3ipq93RMtPopNl2/weroWtUjs2HO73exOtPnBjcRqhTNG8t61UDFW74dVW/xppJhrRcWXm
5GUtGGJ+AB1b5kR8cAV3wvwrLGPTnIlOQ09gE4I61DWVY7Q/ssl2gt5wxddc6tGrbau6tvjy2HZ9
LVfHBvOx//MhJ0TO15WAVF2/UX0noAFQR23FNxshT6xpGgZ5iDx4H4VvJQwIsOr1pSiLFcpGDah7
gb6R5ddGFEgWOZK7KEIhHnlfKZy755ZxHFMYi6x5VRmf/ze2X9Say2//6Fym8zhIH/AhfAAGp4Wt
tz0uyAXCZDZPwnfxYZ4FMX4CelDgIA==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 1 2 574
STR: »

CVS: $Id: sqlparser.lib.php,v 2.27 2004/11/05 00:41:55 lem9 Exp $
MySQL: 4.0.23-standard
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.1
PHP VER,OS: 4.3.11 Linux
LANG: en-iso-8859-1
SQL: ï»¿-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 17, 2005 at 09:56 PM
-- Server version: 4.1.10
-- PHP Version: 4.3.11
-- 
-- Database: `hotrod_forums`
-- 

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

-- 
-- Table structure for table `access`
-- 

CREATE TABLE `access` (
  `userid` int(10) unsigned NOT NULL default '0',
  `forumid` smallint(5) unsigned NOT NULL default '0',
  `accessmask` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`userid`,`forumid`)
) ENGINE=MyISAM 

----END RAW----

SQL-query:

ï»¿-- phpMyAdmin SQL Dump -- version 2.6.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 17, 2005 at 09:56 PM -- Server version: 4.1.10 -- PHP Version: 4.3.11 -- -- Database: `hotrod_forums` -- -- -------------------------------------------------------- -- -- Table structure for table `access` -- CREATE TABLE `access` ( `userid` int(10) unsigned NOT NULL default '0', `forumid` smallint(5) unsigned NOT NULL default '0', `accessmask` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`userid`,`forumid`) ) ENGINE=MyISAM

MySQL said: Documentation
#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 'ï»¿-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpm

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a button banner plz.	iceman35	Graphic Design / Flash	3	04-30-2005 03:05 PM
hey plz help me if you can	grapplefan	Web Design Discussion	1	03-24-2005 08:56 PM
plz review this VB SKIN	jane118	Web Development Wanted	10	07-05-2004 12:30 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)