[ABD] Mood

[PATRICKDAVIS]

SQL query:

ALTER TABLE phpbb_users ADD user_mood TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT 0

MySQL said:

#1142 - ALTER command denied to user 'patdavis'@'server213-171-218-113.livedns.org.uk' for table 'phpbb_users'





What does this error mean

[tbma2008]

i installed and did all the edits. when i go to profile to pick a mood and click submit i get this error

SQL ERROR [ mysql4 ]

Unknown column 'user_mood' in 'field list' [1054]

SQL

UPDATE phpbb_3users SET user_icq = '', user_aim = '', user_msnm = '', user_yim = '', user_jabber = '', user_website = 'http://www.myspace.com/tbma', user_from = 'Fort wayne, Indiana', user_occ = '', user_interests = 'Music, computers, etc.', user_mood = NULL, user_birthday = ' 2- 7-1979' WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/ucp/ucp_profile.php
LINE: 384
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 479
CALL: ucp_profile->main()

FILE: ucp.php
LINE: 328
CALL: p_master->load_active()

[tbma2008]

nevermind sorry.... worked after running db_update.php

[channelasian]

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_mood' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

why when i edit profile it show the message above?

please help me

[pippo-c-l]

Grazie italy!

[Richazey]

Hi ive added an extra 3 moods but when I lcick on on in the ucp i get this

Code: Select all

TOO_LARGE_MOOD

what needs changing?

[Richazey]

Hi i got the new moods working but when i select a new mood the image dont show it just says mood:, ive uploaded the mages and done the right file edits what is best to check?

forgot to edit includes/acp/acp_styles.php,
working great now

[WMCMoo]

Would it be possible to have the mood select as a drop down box instead of Bullet Points ?

Cheers in advance

[DragonMaster1]

does anyone reply to support here?

[Richazey]

For anyone who has this mod i have created 10 icons, like this


I also have these icons to fit the following mods
Gender Mod (didnt create these)

Annual StarMod

Medal Mod

If anyone wants them, drop me a pm with you email and will send you them

[beggers]

Is the version in the original post the current version or have there been updates somewhere in this topic? This looks fairly complicated so I just want to make sure I'm at least using the latest code. Thanks.

[DragonMaster1]

Is the version in the original post the current version or have there been updates somewhere in this topic? This looks fairly complicated so I just want to make sure I'm at least using the latest code. Thanks.

It’s a mess....you need you go through the entire thread to get it all right

This really needs to be UPDATED A.S.A.P.

[DavidIQ]

There are plenty of issues with it and the MOD author has not come back to this topic since June of last year although he's been very active with his other mods. Therefore I am going to assume he has abandoned this MOD, marking it as such and locking it.

Primy, if you would like to reclaim this topic please PM a MOD Team member.