Donate to the B3 fund!

"even a small donation helps!"
Donate with PayPal!
The creator of these plugins has not shown activity in a while. Posting in this board may not result in a fast reply or a reply at all. [ Read the full Support Disclaimer here ]
Most of the plugins here are made by B3 users and the authors may not visit frequently. If you need support for plugins or if questions remain unanswered, you will have to contact the author directly. Read the full Support Disclaimer here

NOTE: Do not attach plugins to your forumtopics! Attachements are periodically removed by maintenance tasks. Upload your plugins to our Downloads section instead!

Author Topic: ctime won't import to SQL  (Read 3048 times)

Offline setman

  • Sr. Member
  • ****
  • Posts: 208
ctime won't import to SQL
« on: December 06, 2011, 11:08:23 PM »
I have been trying to import ctime sql into my database, but it keeps coming up with this error.

#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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 20

Offline MordyT

  • Support Hero
  • Hero Member
  • *
  • Posts: 3644
  • Over $300 Donated to B3!
    • MordyT
Re: ctime won't import to SQL
« Reply #1 on: December 06, 2011, 11:48:47 PM »
open the .sql file with notepad++
find and replace TYPE with ENGINE
save file, re-import
Help will be given to those with a b3.log

If drop off the map it is due to RL becoming busy :)

System: Python 2.7.3 - Deb 7 - B3 Source Code - 128MB RAM box (rented at $5 a year) - remote MySQL - Remote Web Services

Offline setman

  • Sr. Member
  • ****
  • Posts: 208
Re: ctime won't import to SQL
« Reply #2 on: December 07, 2011, 01:34:08 AM »
Thanks again Mordy

 


Rate this page +1 at Google Search

anything