Fatal error in indexpage

[demingel]

I have run this into the database but it did not found any lines

Code: Alles auswählen

UPDATE phpbb_users SET user_birthday = 999999 WHERE user_birthday = '' OR user_birthday IS NULL;

[oxpus]

But the Birthday MOD is still installed?

[demingel]

yes the birthday mod is still installed
so mayby the problem is in the eventlist for callite I don't now?

[Morun]

those people who are shown in the event list with birthday on 1.1., what do theyhave as birthday in the data base?

[oxpus]

If you have the wrong values in the field user_birthday, the usercp_register.php will be wrong!
Check the installation in this file, especially the changes in the UPDATE and INSERT INTO the users table!

[demingel]

if I look into the database I see this in user_birthday

Code: Alles auswählen

user_birthday  varchar(8)   Yes  0  

0 is standardvalue
varchar(8) is type
yes is NULL

[Morun]

that just the structure. click on browse or something similar to see the values in the data rows of the table.

[oxpus]

Default must be 999999. Change the field, please...

[demingel]

I changes the field butt the users are still visible on 1-1-2007
Do/must I have to change all things regarding the birthdays?
like user_last_birthday
user_next_birthday_greeting

Code: Alles auswählen

ALTER TABLE `phpbb_users` CHANGE `user_birthday` `user_birthday` VARCHAR( 8 ) DEFAULT '999999' 

[oxpus]

The fields with "0" must be changed to 999999, too.
Use this statemant:

Code: Alles auswählen

UPDATE phpbb_users SET user_birthday = 999999 WHERE user_birthday = 0;

[demingel]

I did someting very stupid I deleted my user_table
I have a backup from the database butt i can"t installed

I have now this error

Code: Alles auswählen

phpBB : Critical Error 

Could not get theme data for themes_id [5] 

[oxpus]

With which tool you will restore the database?

[demingel]

with phpmyadmin
butt I ask my host to run the backup from last week over the current one so the problem will be gone by tomorrow i hope
and then I do the birthday mod again and make a backup from the board