sql install

[umiya]

 when doing the sql isntall and on this step

Code Select Expand

INSERT INTO `servers` VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');

mysql puts out the following

Code Select Expand

MySQL said:
#1136 - Column count doesn't match value count at row 1

any fix for it?

[Veranor]

when doing the sql isntall and on this step

Code Select Expand

INSERT INTO `servers` VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');

mysql puts out the following

Code Select Expand

MySQL said:
#1136 - Column count doesn't match value count at row 1

any fix for it?

You'll hit that problem on several steps I believe. I think you have there are too many/few values you are trying to insert. I either deleted one from the  Query or from the table, though neither is probably the right idea.


Retto?

[umiya]

 this is the only one i had the problem with everything else i got jsut fine :)

[Ashaman]

 Why don't you specify the fields to be sure?

INSERT INTO `servers` (Field1, Field2, etc...) VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');

Just to make sure that there are enough fields to every values.  And to not leave SQL determine what values goes into what default field.

[umiya]

 only if i knew how

[Ashaman]

 Well, try this.

First, get a description of the servers table to see what fields belong in that table.  I believe it is

desc servers

Then, match up all the fields with the correct values from your values statement.  For example:

INSERT INTO `servers` (GameType, GameName, Value1, Value2, Value3, Value4, TurnsAvailable) VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');

Now, the field names used in the above statements are purely fictionals.  But I hope you get the idea behind it and understand what those values you're trying to insert into the table actually mean.

[umiya]

 CREATE TABLE `servers` (
 `name` varchar(50) NOT NULL default '',
 `title` varchar(200) NOT NULL default '',
 `players` int(11) NOT NULL default '0',
 `turns` int(11) NOT NULL default '0',
 `reset` tinyint(3) unsigned NOT NULL default '0',
 `hidden` tinyint(1) unsigned NOT NULL default '0',
 `url` varchar(200) NOT NULL default '',
 `news` text NOT NULL
) TYPE=MyISAM;

use this to base ur mysql query for i cant figure it out...i have no experience with mysql quiers so i really dont know how it should look

[Ashaman]

 Well, I have no idea why you want to insert this VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');
into the servers table.  I thought you already know what those values stand for.  However, looking at the servers table, it appears many of those field already have default values and thus, don't need to be specified in the insert statement unless the values are different from the default values.

Hence, I'll take a wild guess at the meaning of the values you're trying to insert.
VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');
'prom' - stand for server name?
'Promisance' - probably is the title of the game
'No Turns Yet!' - either belong to "url" field or "news" field.  I guess it's the "news" field since it doesn't look anything like an "url"
So, to make MySQL stop complaining, you can do the following line (NOTE: this will only make MySQL not complain, it doesn't guarantee the values were intended for the fields being used)


INSERT INTO `servers` (name, title, news) VALUES ('prom', 'Promisance', 'No Turns Yet!');
*the 4 0's are not needed since they are already defaulted.  Or you could do the following if you don't want to remove the 4 0's
INSERT INTO `servers` (name, title, players, turns, reset, hidden, news) VALUES ('prom', 'Promisance', 0, 0, 0, 0, 'No Turns Yet!');

[bjornredtail]

 http://www.redwallwarlords.com/forums/index.php?a...t=ST&f=7&t=5121

Yes, I already found it. *digs out setup script*

Code Select Expand

$insert["servers"] = "INSERT INTO `servers` VALUES ('$config[server]', '$config[servname]', 0, 0, 0, 0, '$config[sitedir]', 'No Turns Yet!');";

Copypaste that over the insert function for the servers table. That ought to work, assumeing you set the $config[sitedir] variable up correctly. The problem is Retto forgot to put the ULR of the server into the insert function.  

[umiya]

 

http://www.redwallwarlords.com/forums/index.php?a...t=ST&f=7&t=5121

Yes, I already found it. *digs out setup script*

Code Select Expand

$insert["servers"] = "INSERT INTO `servers` VALUES ('$config[server]', '$config[servname]', 0, 0, 0, 0, '$config[sitedir]', 'No Turns Yet!');";

Copypaste that over the insert function for the servers table. That ought to work, assumeing you set the $config[sitedir] variable up correctly. The problem is Retto forgot to put the ULR of the server into the insert function.

that stilll isnt right, i used what ashaman said then mauly added the site url and it turned out good for me....but now im getting errors trying to login :S

ok i got the login fixed but how do i take it out of lite view.....once ur logged in its in lite mode and i cant figure out how to turn it off :|

[bjornredtail]

 Now that is weird.... Problem is in rwl.php (or is it html.php... Can't rember off hand. One of the two). Only thing is I don't know why it wouldn't work on your end, but it does work on mine...