• 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!

Problem With WebSite and SQL Database Help Plx!

V

Vikarious

New Member
Joined
Dec 16, 2008
Messages
93
Reaction score
2
Well, this is my first post here and i hope someone be able to hlep me fix this, in forum form the country of wich im for, about ot's, nobodys asnwered me eighter a lot of other ppl haivng this same problem, and a lot of ppl are having this problem...


Well, lets begin, when i first runned my ot, of ocurse i had made the database thing with xampp, pretty easy till here, so when i did the hting of import the database i had this msg form xmpp


Erro

consulta SQL:
DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` !=1 AND `type` !=2 AND `value` = OLD.`id` ;


Mensagens do MySQL :
#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


~~~

But it were not a problem, cuz' i still could ran the server normally, but with one small problem: i could not see account or guild or player by xampp, only acc 1/1 and player Acc Manager, i had to use sqlite studio, this is also ok for me, but it is a thing very strange.

~~~
Detail of: schema.mysql


when i import it, i have a database with 23 tables, the file has 11,8 KB (12,00)
~~~

Well, this is the first part of my problem, as i said i could never see or manage the player via xampp.

The second part of my problem is: i installed my website, and it could not see the players to use in rankings or in 'search for player', i tonly shows the acc manager, i dont know if that sql error have some relation with this second problem, bu tim sure that, when i be able to use xampp to manage my player and etc, i would be able to run the site perfectely.


~~

More info: In my config.lua i pu tin this way

-- Database
-- NOTE: sqlFile is used only by sqlite database
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "*****"
sqlPass = "*****"
sqlDatabase = "schema"
sqlFile = "forgottenserver.s3db"
passwordType = "plain"


~~

Some ppl said to chnage sqlType = "sqlite" for sqlType = "mysql"

but when i do this, server can not run.


Someone please, have an idea of what can be done or anything that be?

please, i really need this help, and having this help maybe i be able ot help the ppl who are haing this problem too here in Brazil.


Ty for attention =)
 
Sort by date Sort by votes
Marcinek : Im gonna do this right now, and see what happen, thanks till now for oyur attention =)


Invisible Elf: yes, it is running normally, i just dont know what is happning, after try what Marcinek told me, i ocme back and edit this post =)


TY for help and patience!!
 
Upvote 0 Downvote
When you set from sqlite to mysql the server cannot run because you have to edit sqlUser, Password and Database to the ones used by XAMPP in config, just near sqlType.
 
Upvote 0 Downvote
alirght ppl, the thing of update phpMyadmin worked perfetc.


after what you told me Marcinek about mysql, i tried a couple of times and i could do it.

but when i open the database 'otserv' via phpmyadmin i only can see acc manager like before, BUT, when i try to connect using my old password i see that i could not (remembering that im not using sqlite mode but mysql), so, i understood: this new db is one beginning from zero, well, my question is: there is a form to dont lose my old database?

my forgottenserver.s3db is already with 400+ kb, i have a lot of player with high levels, there is something i could do to dont lose it? a form to import it? or something? or this is just impossible?


and i have a little question: can i make a tread in our bazilian otserv forum wiht all this information? with credits of coures and link to the originals? if you let me, once its made i send oyu the link if you wish to see, a lot of ppl here are having the same problems =X


thanks once again!! >.<
 
Upvote 0 Downvote
Vikarious said:
alirght ppl, the thing of update phpMyadmin worked perfetc.


after what you told me Marcinek about mysql, i tried a couple of times and i could do it.

but when i open the database 'otserv' via phpmyadmin i only can see acc manager like before, BUT, when i try to connect using my old password i see that i could not (remembering that im not using sqlite mode but mysql), so, i understood: this new db is one beginning from zero, well, my question is: there is a form to dont lose my old database?

my forgottenserver.s3db is already with 400+ kb, i have a lot of player with high levels, there is something i could do to dont lose it? a form to import it? or something? or this is just impossible?


and i have a little question: can i make a tread in our bazilian otserv forum wiht all this information? with credits of coures and link to the originals? if you let me, once its made i send oyu the link if you wish to see, a lot of ppl here are having the same problems =X


thanks once again!! >.<
Click to expand...

I would not have any problem with you posting it anywhere, unless you keep the original links @OtLand.

To the first question... Im somewhat 98% sure you can not import your SQLite Database into MySQL one, try Google. :P
 
Upvote 0 Downvote
ok, thanks Macinek, for you allow me to do that, im gonna send oyu right now the link via p.m.


You will see the credits in the end of tread.

Thanks a lot again =)
 
Upvote 0 Downvote
Back
Top