VISIT AND LIKE OUR PAGE ON FACEBOOK
TAKE A LOOK AT OUR TWEETS ON TWITTER
SUBSCRIBE TO THE JOOMFREAK RSS FEED
CHECK OUT OUR PAGE ON GOOGLE +
VISIT OUR CHANNEL ON YOUTUBE

Account Details

Change your name, email, password or permanently delete your account. Change settings

We offer several ways you can get support from our experts: Support ForumKnowledgebaseNewsletter

Your Forum Posts

No posts to display.

Welcome, Guest
Username Password: Remember me

Error while trying to upload sql file on liveserve
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Error while trying to upload sql file on liveserve

Error while trying to upload sql file on liveserve 21 Jul 2016 08:22 #9177

Hi,
I setup jf krom using quickstart i downloaded here after i have finished the whole website on local host now trying to upload the sql file into live server database i got this error:

Error
SQL query:

-- --------------------------------------------------------
--
-- Table structure for table `gvony_assets`
--
CREATE TABLE `gvony_assets` (

`id` INT( 10 ) UNSIGNED NOT NULL COMMENT 'Primary Key',
`parent_id` INT( 11 ) NOT NULL DEFAULT '0' COMMENT
);

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 ')' at line 4

pls help i attched the sql file
Attachments:
  • Attachment This attachment is hidden for guests. Please log in or register to see it.
Last Edit: 21 Jul 2016 08:24 by softlog.

  • Posts:2
  • softlog
  • Fresh Boarder
  • OFFLINE
  • Karma: 0

Re: Error while trying to upload sql file on liveserve 22 Jul 2016 03:42 #9182

What is your MySQL server version?

joomfreak

  • Posts:2028
  • isupport
  • Moderator
  • OFFLINE
  • Karma: 0

Re: Error while trying to upload sql file on liveserve 22 Jul 2016 06:11 #9183

MySQL version on my wampserver in which i used in developing the site is 5.7.11 the one on my liveserver in which i'm trying to import the sql file is version 5.5.44.


Thank you so much for helping me look into this matter
Last Edit: 22 Jul 2016 06:17 by softlog. Reason: i just got reply from my hosting telling the version of the MySQL

  • Posts:2
  • softlog
  • Fresh Boarder
  • OFFLINE
  • Karma: 0

Re: Error while trying to upload sql file on liveserve 25 Jul 2016 03:42 #9187

How did you export the sql file? Your sql file has too much error.
You can use component akeeba to create backup and upload to your server.

joomfreak

  • Posts:2028
  • isupport
  • Moderator
  • OFFLINE
  • Karma: 0
  • Page:
  • 1
Time to create page: 0.57 seconds

joomfreak is not affiliated with or endorsed by the Joomla Project or Open Source Matters.
The Joomla logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.