Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 5 of 5
  1. #1
    Senior Member
    Join Date
    Aug 2003
    Posts
    194
    Member #
    2782
    Hi Everyone,
    Due to some issues, I have to reinstall my CMS. I backed up the database using phpMyAdmin's export feature. When attempting to drop the code back into the database, I am receiving the following error:

    Code:
    -- Table structure for table `cms_additional_htmlblob_users`
    -- 
     CREATE TABLE `cms_additional_htmlblob_users` (
    `additional_htmlblob_users_id` int( 11 ) NOT NULL ,
     `user_id` int( 11 ) default NULL ,
     `htmlblob_id` int( 11 ) default NULL ,
     PRIMARY KEY ( `additional_htmlblob_users_id` )
    ) ENGINE = MYISAM DEFAULT CHARSET = utf8;
    
    
    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 `cms_additional_htmlblob_users` (
       `additional_htmlblob_user' at line 1
    I am not well versed in mySQL, so I am not sure how to fix this. Any help is appreciated. Thank you.

  2.  

  3. #2
    Senior Member Ganners's Avatar
    Join Date
    Feb 2011
    Location
    United Kingdom
    Posts
    415
    Member #
    27007
    Liked
    92 times
    Pretty odd, there are no errors I can see with this query.

    Have you only tried importing the sql file, or did you paste this and execute this as SQL in phpMyAdmin?
    Abstract likes this.
    Mark Gannaway Software Developer

    Recent Experiments
    - Backpropogation Neural Network language solving (http://ann.ganners.co.uk/)
    - Animated image to ASCII (http://google.ganners.co.uk/)
    - 3D Paper Characters (http://cybergame.ganners.co.uk/)
    - Anagram solving (http://roflol.co.uk/)

  4. #3
    Senior Member
    Join Date
    Aug 2003
    Posts
    194
    Member #
    2782
    I have only tried to import the file; let me try to execute in the SQL window and what happens...

  5. #4
    Senior Member
    Join Date
    Aug 2003
    Posts
    194
    Member #
    2782
    It worked!!! Thank you for your prompt assistance.

  6. #5
    Senior Member Ganners's Avatar
    Join Date
    Feb 2011
    Location
    United Kingdom
    Posts
    415
    Member #
    27007
    Liked
    92 times
    No problem, glad I could help
    Mark Gannaway Software Developer

    Recent Experiments
    - Backpropogation Neural Network language solving (http://ann.ganners.co.uk/)
    - Animated image to ASCII (http://google.ganners.co.uk/)
    - 3D Paper Characters (http://cybergame.ganners.co.uk/)
    - Anagram solving (http://roflol.co.uk/)


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 10:37 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com