gVectors Team

Professional WordPress Plugins and Services. wpDiscuz, WooDiscuz, Advanced Post Pagination

Search
Close
AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Forums
Plugin Support
wpForo
mysql error
 
Notifications
Clear all

mysql error

  ✦ Summarize Topic
wpForo
Last Post by Astghik 8 years ago
2 Posts
2 Users
0 Reactions
2,068 Views
RSS
 fiatlux
(@fiatlux)
New Member
Joined: 8 years ago
Posts: 1
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
19/02/2018 7:24 pm   [#2009]

Hi,

Importing a copy of my wp database onto a local OS X server running MAMP I get an 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 '' at line 1
 
One solution discussed on the net said to change the table to MyISAM and then add FULLTEXT to the column index.  I'm having trouble accomplishing that.  
 
Has this been seen before?
Thanks,
Jason

Screen Shot 2018 02 19 at 9.47.21 AM
 


   
Quote
Astghik
 Astghik
(@astgh)
Illustrious Member Admin
Joined: 8 years ago
Posts: 6645
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
20/02/2018 1:59 pm  

Hi fiatlux,

1. Please update MySQL local server version.

2. If it doesn't help, remove tables, (which are recently created during import) from local server, then edit .sql file, find all ENGINE=MyISAM and replace to ENGINE=MyISAM, save and start to import to local server.



   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share:
Scroll to top