MODS.DB9.DK

[Smatrix3]

Could not update users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_autospell' in 'field list'

Msg in English :

Saddened, I am not strong englais,
But I have to install this mod and when I choose male or femele and when I valid I obtain an error. That below
I made a research in the forum I have to find nothing who can use.

A good soul in the assistance plz.

Msg in French :

Désolé, je ne suis pas fort en englais,

mais j'ai installer ce mod et quand je choisis mâle ou femele et que je valide j'obtiens une erreur. celle ci-dessous

j'ai fait une recherche dans le forum j'ai rien trouver qui puisse m'aider.

une bonne âme dans l'assistance plz.

[kooky]

Salut

Cette ligne "user_autospel" fait référence à une entrée inconnue, sûrement après l'ajout d'un nouveau mod

L'erreur doit se situer sur la ligne $sql = "UPDATE " . USERS_TABLE . "....

[Hawk-Metal]

I have the same problem

Could not update users table

DEBUG MODE

SQL Error : 1054 Unknown column 'user_gender' in 'field list'

UPDATE phpbb_users SET user_email = 'my_email', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 0, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 0, user_dateformat = 'd M Y h:i a', user_lang = 'english', user_style = 1, user_active = 1, user_actkey = '', user_gender = '1' WHERE user_id = 2

Line : 464
File : /home/path_to_website/public_html/forumZ/includes/usercp_register.php

EasyMOD didn't report any error, it installed everything ok... dunno why this happens...

[Hawk-Metal]

please help... but on english... I don't understant what is written up there

[kooky]

This line said

SQL Error : 1054 Unknown column 'user_gender' in 'field list'

This column was not created
you didn't run SQL queries with the file gender_db_update.php

[Hawk-Metal]

tnx for help!

[geoo]

The SQL-thing is that query, that is not done by Easy Mod Installer, right?

When I enter the query in PHP My Admin, will it work? I just uploaded the gender-Files to phpBB2/admin/mods.

[kooky]

The SQL-thing is that query, that is not done by Easy Mod Installer, right?

When I enter the query in PHP My Admin, will it work? I just uploaded the gender-Files to phpBB2/admin/mods.

No
the file must be upload to your phpBB2 root with index.php, memberlist.php...
then run it into your browser like: http://www.yourdomain.com/phpBB2/gender_db_update.php

if you can't, here is the complete queries for mySQL

Code: Select all

ALTER TABLE phpbb_users ADD user_gender TINYINT NOT NULL DEFAULT '0';