sign up bug

[generalbg]

Ok i make the schedule task to be every hour from 00:00 to 24:00 but it dont seems to work.So i would like to ask where exactly on the main page can i find the cronless version i n development because i cant find the link.Give me the link here in the forum please

[generalbg]

Vernar. The scheduled tasks seems to not work.I dont know whats wrong it asks me for password when i make the scheduled i type my password but it says thats inccorect and the schedule itself upgrades with the new changes i dont know its better to download the cronless version in development.And if i find bug or something else i will write you

[The Beatles]

http://dev.staronesw.com/ <-- The main page has a Download link on the left. Use that.

[generalbg]

When i hit download:
"The page you are looking for cannot be found"

[Veranor]

Download link works now.


(Ran upd-zip.sh in /dev/ and renamed /dev/faf-dev.zip to /dev/faf.zip because "download" link redirects to faf.zip not faf-dev.zip)

[generalbg]

hi i setup the new dev version but when i run the script i get this:Column count doesn't match value count at row 1
And the normal game window but when i try to log in with admin;password:
NO SUCH USER
help pls!

[Veranor]

hi i setup the new dev version but when i run the script i get this:Column count doesn't match value count at row 1
And the normal game window but when i try to log in with admin;password:
NO SUCH USER
help pls!

Wait, what page displays the count error? That shows up when you go to the login page before even logging in?


Did you delete the old tables or set up different tables in config.php for the dev version?

[s]My guess is that when the sql_setup code is run it does not create the new table for players (which has an extra column) and so when it tries to insert the[/s]

EDIT: Apparently std_bld is missing in the INSERT query in the sql-setup.php, along with turns_last and hours_last and all the other _lasts.


To get around this, manually create a user named "admin" and then edit it with phpmyadmin so that num=1 and disabled=2 OR if you do not have phpmyadmin (you should install it, it's a huge help) edit sql-setup.php and add this to the top (untested):

code: Select all

if(mysql_num_rows(mysql_query("SELECT num FROM $playerdb WHERE 1;")) != 0) {
	mysql_query("UPDATE $playerdb SET disabled=2,num=1 WHERE username='admin';");	
}

[generalbg]

Actually i dont understant you much.I tupy localhost and the whole page shows but up there is a small text:
Column count doesn't match value count at row 1
and this is not only on the login page but everywhere i go.So explain me again how to fix this?

[Veranor]

Actually i dont understant you much.I tupy localhost and the whole page shows but up there is a small text:
Column count doesn't match value count at row 1
and this is not only on the login page but everywhere i go.So explain me again how to fix this?

Ok. For now just ignore the error. Sign up an account called "admin". Then add this to the top of sql-setup.php (I have not tested this but it should work):

code: Select all

if(mysql_num_rows(mysql_query("SELECT num FROM $playerdb WHERE 1;")) != 0) {
mysql_query("UPDATE $playerdb SET disabled=2,num=1 WHERE username='admin';");
}

Now go back to the login page. The count error should be gone. Now login with the admin account you signed up. It should display the administration info at the top ("User Administration, Clan Administration" etc.) If it does then you are successful and can remove the above lines that you added to the top of sql-setup.php.

[The Beatles]

Just a clarification: the user name must be admin, the warband name itself isn't important.

[The Beatles]

sql-setup.php has been updated. Closing.