WordPress.org

1. xctechs
   Member
   Posted 4 months ago #

   Error
   SQL query:

   --
   -- Database: bision_vlogs
   --
   -- --------------------------------------------------------
   --
   -- Table structure for table wp_commentmeta
   --
   -- Creation: Oct 19, 2011 at 04:18 AM
   -- Last update: Jan 19, 2012 at 03:54 PM
   -- Last check: Jan 18, 2012 at 03:02 AM
   - - db399572017 DROP TABLE IF EXISTS wp_commentmeta

   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 '--db399572017

   DROP TABLE IF EXISTS wp_commentmeta' at line 13

   I have contacted our new host 1and1 and they have indicated to me that i am using old sql but talking to my old provider which is psychz they showed me they are using "Server version: 5.1.56"

   I have checked with old host and they have checked my sql file and nothing is wrong, i hope someone has a resolution I can't think of a way to fix this,

2. netcs.vg
   Member
   Posted 4 months ago #

   Im not sure which file this is coming from but the error is because of the extra space in : '- - db399572017 DROP TABLE IF EXISTS wp_commentmeta'
   if you see the prior lines they start with -- (a comment line), except the last line that starts with - -.
   so if you take out that space most likely your query will run...

3. xctechs
   Member
   Posted 4 months ago #

   this file is from backup sql for full backup for wordpress blog

4. xctechs
   Member
   Posted 4 months ago #

   i checked its not an space :(

Reply

You must log in to post.