• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Sql help

B

Beef Jerky

New Member
Joined
Sep 19, 2008
Messages
68
Reaction score
0
i cant find Frgottenserver.sql blah blah


in the msqlhelp thing i am on this step Use the 'File to import' part, select forgottenserver.sql and press on 'Go'.


could anyone tell me where to find this forgottenserver.sql?:o
 
Sort by date Sort by votes
Beef Jerky said:
i cant find Frgottenserver.sql blah blah


in the msqlhelp thing i am on this step Use the 'File to import' part, select forgottenserver.sql and press on 'Go'.


could anyone tell me where to find this forgottenserver.sql?:o
Click to expand...

It should be in the folder with your server and config.lua file. If the file open window has it set to just .sql files, change it to all files (types) and you should see it.

Jo3
 
Upvote 0 Downvote
hueuz4.jpg







this is the folder?

i dont see anything that says for~ or eclipse :/


this is so confusing :> sorry guys
 
Upvote 0 Downvote
Gangsta-jr said:
other files ;)
in there ull find eclipse.sql
Click to expand...




this is wat poped up after i hit go.
Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;



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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1
 
Upvote 0 Downvote
Beef Jerky said:
this is wat poped up after i hit go.
Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;



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 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
' at line 1
Click to expand...
Make sure you have the newest version of MySQL, and PHPMyAdmin then try importing it again.

Jo3
 
Upvote 0 Downvote
How is there an older version? and another question how do i make characters show up on the Sql, i got it to work but characters and acc's arnt showing up, but i thibk that goes back to the hole me not having the right version thing...
 
Upvote 0 Downvote
Beef Jerky said:
How is there an older version? and another question how do i make characters show up on the Sql, i got it to work but characters and acc's arnt showing up, but i thibk that goes back to the hole me not having the right version thing...
Click to expand...

There's an older version to basically every piece of software/hardware ever made. I know that MySQL 4.x returns those errors, but MySQL 5.x doesn't. And yes, it has to do with the problem you're having.

Jo3
 
Upvote 0 Downvote
Beef Jerky said:
Were can i download this 5.x and that other thing u said i needed new Version of?
Click to expand...

If you're using MySQL only go here: MySQL :: MySQL 5.0 Downloads.
If you're using xampp go here: apache friends - xampp.
I believe you can update PHPMyAdmin from the the control panel, where you imported the sql file, but I think if you're using the newest version of MySQL or xampp then you won't have to update PHPMyAdmin.

Jo3
 
Upvote 0 Downvote
Idk what Sqlyog is :/ im new to this, im trying to host a 8.22 OT and i havnt hosted since 7.6 and they sure did change a lot of things ;\
 
Upvote 0 Downvote
Upvote 0 Downvote
Beef Jerky said:
I downloaded the Sql 5.0 thing tho :p wish u could phone me for walk threw lol
Click to expand...

Lol, the only reason I use MySQL instead of xampp is because I don't want to host a site, so I don't need Apache. But I suggest following that tutorial and using xampp since you're basically new to this.

Jo3
 
Upvote 0 Downvote
Back
Top