[Guide] set up your server with Spartansp Repack V3 (public)

[blank288]

So i open the sql with what and change what to 255

[cherl]

i have a problem, when i logon, i try to create a character and it automaticly disconnect me when i create it. It does for every other player too. What should i do?

[blank288]

How can I fix this I read page seven but it doesn't help me very well? This is the problem
[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead
[Err] -- ----------------------------
-- Table structure for wordfilter_character_names
-- ----------------------------
CREATE TABLE `wordfilter_character_names` (
`regex_match` varchar(500) NOT NULL,
`regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead
[Err] -- ----------------------------
-- Table structure for wordfilter_chat
-- ----------------------------
CREATE TABLE `wordfilter_chat` (
`regex_match` varchar(500) NOT NULL,
`regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[TehShyOne]

Hey is this the newest version of spartan repack and which one should you get one with seperate or one with full? please help them 2 questions please and thanks.

[TehShyOne]

Hey I need help please help thanks.
Ok well... Is v3 the newest? And also which would be better to get the download link with fullsp or the one seprate please help thanks.

And another question seperate hmm... For the MySQL which be better to download
.Windows Essentials (x86)
.Windows ZIP/Setup.EXE (x86)
or .Without installer (unzip in C:\)
please help me these questions thanks !

[Spartansp]

So i open the sql with what and change what to 255

better reinstall the one that says FullSPDB

i have a problem, when i logon, i try to create a character and it automaticly disconnect me when i create it. It does for every other player too. What should i do?

Fix character_insert_queue or reinstall all stuff again

Hey is this the newest version of spartan repack and which one should you get one with seperate or one with full? please help them 2 questions please and thanks.

better use the FullSPDB one

Hey I need help please help thanks.
Ok well... Is v3 the newest? And also which would be better to get the download link with fullsp or the one seprate please help thanks.

And another question seperate hmm... For the MySQL which be better to download
.Windows Essentials (x86)
.Windows ZIP/Setup.EXE (x86)
or .Without installer (unzip in C
please help me these questions thanks !

Yea V3 is newest V4 will be released in sunday or monday all depends if i get all things working correctly

[foxfire]

Ok so i did everything like you said. i got on and everything working fine... Except Mounts arent working? I use the mount but it doesnt show me riding it or the speed boost?

[Spartansp]

fox fire that question has been made in all pages now... i ask you kindly to see all other pages before asking an already answered question.

Glad you liked it... and remember if you get help on someone else rep him aswell look at my sig

[LampShade]

Here is a screenshot of the error i get whenever I try to Execute spdb.sql into Navicat:

FINALLY! I found the issue with this. If anyone gets this error when trying to execute Spartan's repack in Navicat, then make sure you DO NOT have version 4 of MySQL. I uninstalled MySQL 4.0, and installed MySQL 5 and it fixed the problem!

[Spartansp]

in my guide i was telling that you need mysql 5 enterprise edition lol :P

[Mike3667]

When I create a character, it doesn't show up on my character selection page.

[blank288]

Thanks to lampshade i got the errors to go away. I was using mysql 4 to i doesn't work. Very nice repack love it +Rep

[blank288]

hey i was just wondering where are the admin and gm armor set at? and how do i get the spells the gms use?

[Spartansp]

When I create a character, it doesn't show up on my character selection page.

characters table may be broken or missing

Thanks to lampshade i got the errors to go away. I was using mysql 4 to i doesn't work. Very nice repack love it +Rep

thanks mate glad you liked it

hey i was just wondering where are the admin and gm armor set at? and how do i get the spells the gms use?

they are in GMIsland above the house you need to .cheatfly to get on top
to have GM commands you need to put in accounts table under the "GM" column AZ

[playboyys]

How is V4 coming along?