Navicat Error Executing SQL file

[GamerX]

Hey Guys I'm making a retro in my vps windows 2008 but when I try importing my db it comes up with the error like this

You must be registered for see links

If someone can help would be really appreciated


Sent from my iPad using Tapatalk

 

[Xuxu]

im assuming youre trying to use the plus db from sulake.cc? those are no good take the clean plus db from the emu on *****.com and it will work fine

 

[GamerX]

im assuming youre trying to use the plus db from sulake.cc? those are no good take the clean plus db from the emu on *****.com and it will work fine

But my db has the latest features


Sent from my iPad using Tapatalk

 

[NathanCarn3y]

Hey Guys I'm making a retro in my vps windows 2008 but when I try importing my db it comes up with the error like this

You must be registered for see links

If someone can help would be really appreciated


Sent from my iPad using Tapatalk

link to hotel?

 

[GamerX]

link to hotel?

Yes


Sent from my iPad using Tapatalk

 

[NathanCarn3y]

Yes


Sent from my iPad using Tapatalk

whats the link

 

[Xuxu]

But my db has the latest features

Sent from my iPad using Tapatalk

what db r u using? is it a normal plus db or a edit from a release thread?

 

[GamerX]

whats the link

habvenue.pw


Sent from my iPad using Tapatalk

 

[GamerX]

what db r u using? is it a normal plus db or a edit from a release thread?

A edit but not released


Sent from my iPad using Tapatalk

 

[Queso]

What you can do is, select the box hat says, "Continue on errors," and it should continue the uploading process, or you could put your database in pastebin.com, and I will check it out for any errors, as I'm pretty sure it's just an error in the sql file.

 

[Xuxu]

A edit but not released


Sent from my iPad using Tapatalk

what exactly was edited? cant u use a working db and copy the updated tables over?

 

[NathanCarn3y]

Hey Guys I'm making a retro in my vps windows 2008 but when I try importing my db it comes up with the error like this

You must be registered for see links

If someone can help would be really appreciated


Sent from my iPad using Tapatalk

you need to fix hote_id in database i cant registered

 

[Xuxu]

What you can do is, select the box hat says, "Continue on errors," and it should continue the uploading process, or you could put your database in pastebin.com, and I will check it out for any errors, as I'm pretty sure it's just an error in the sql file.

true if u want a non functioning hotel with missing data and tables that is....

 

[GamerX]

what exactly was edited? cant u use a working db and copy the updated tables over?

It has cata layout the latest one and more


Sent from my iPad using Tapatalk

 

[Queso]

true if u want a non functioning hotel with missing data and tables that is....

By the looks of it, it doesn't look like it's something wrong with any structures, it's clearly a table, that has truncated data inside it.

 

[GamerX]

How can I import the sql file successfully ?


Sent from my iPad using Tapatalk

 

[Brought]

How can I import the sql file successfully ?


Sent from my iPad using Tapatalk

Have you turned off MySQL strict mode?
Run this Query in the database you created before importing your SQL file.

SET sql_mode = '';

 

[GamerX]

Have you turned off MySQL strict mode?
Run this Query in the database you created before importing your SQL file.

SET sql_mode = '';

How to turn off Mysql strict mode?


Sent from my iPad using Tapatalk

 

[regimozz]

How to turn off Mysql strict mode?


Sent from my iPad using Tapatalk

On your Navicat Installation, click your database > click query > In the white text box enter SET sql_mode = ''; > Click Run
That should allow you to run that query.

It may also help if you post the actual error. If you scroll to the top of your import prompt, it will tell you the actual error that's stopping the import of the database

Regards,

 

[GamerX]

On your Navicat Installation, click your database > click query > In the white text box enter SET sql_mode = ''; > Click Run
That should allow you to run that query.

It may also help if you post the actual error. If you scroll to the top of your import prompt, it will tell you the actual error that's stopping the import of the database

Regards,

That doesn't work either



Sent from my iPad using Tapatalk