Problem With usercp_register.php

Mod that adds a extra field to the users profile, the gender is displayed beside the posts

Moderator: Moderators

Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

Problem With usercp_register.php

Postby Smatrix3 on Wed 25. Aug, 2004 16:38

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.
Smatrix3
Poster
Poster
 
Posts: 4
Joined: Tue 19. Aug, 2003 19:07

Postby kooky on Thu 26. Aug, 2004 02:25

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 . "....
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Postby Hawk-Metal on Tue 07. Sep, 2004 01:06

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
Poster
Poster
 
Posts: 3
Joined: Tue 07. Sep, 2004 00:51

Postby Hawk-Metal on Tue 07. Sep, 2004 22:20

please help... but on english... I don't understant what is written up there :wink:
Hawk-Metal
Poster
Poster
 
Posts: 3
Joined: Tue 07. Sep, 2004 00:51

Postby kooky on Wed 08. Sep, 2004 01:57

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 :wink:
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Postby Hawk-Metal on Wed 08. Sep, 2004 02:09

tnx for help! :D
Hawk-Metal
Poster
Poster
 
Posts: 3
Joined: Tue 07. Sep, 2004 00:51

Postby geoo on Thu 09. Sep, 2004 10:10

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.
geoo
Poster
Poster
 
Posts: 1
Joined: Thu 09. Sep, 2004 10:06

Postby kooky on Fri 10. Sep, 2004 01:01

geoo wrote: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';
kooky
brilliant supporter
 
Posts: 1329
Joined: Tue 31. Dec, 2002 17:52
Location: Au pays des rêves

Next

Return to Gender [2.0.10/EM]

Who is online

Users browsing this forum: No registered users and 2 guests

cron