Error met Allowances

[cartoontje]

Deze mod geïnstalleerd:

Code: Selecteer alles

############################################################## 
## MOD Title: Allowance MOD
## MOD Author: Napoleon <napoleon@inetangel.com> (Chris Moore) www.iNetAngel.com
## MOD Description: Stand alone Currency with user rewards / allowance system
## MOD Version: 1.0.0 
## 
## Installation Level: (Intermediate) 
## Installation Time: 20 Minutes 
##
## Files To Edit:	index.php
##			memberlist.php
##			privmsg.php
##			viewtopic.php
##			includes/functions_post.php
##			includes/usercp_viewprofile.php
##			admin/admin_ranks.php
##			admin/admin_users.php
##			templates/subSilver/memberlist_body.tpl
##			templates/subSilver/profile_view_body.tpl
##			templates/subSilver/admin/user_edit_body.tpl
##			templates/subSilver/admin/ranks_edit_body.tpl
##			templates/subSilver/admin/ranks_list_body.tpl
##
## Included Files:	admin_allowance.php
##			allowance_body.tpl
##
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
############################################################## 
## Author Notes:  eXplosives Point System isn't supported with
##			this MOD however you only need to change all
##			instances of "user_points" to "user_money"
##			and vice versa to get this to work with
##			the Points System. This MOD will work with 
##			Xores MoneySystem since Xore's MoneySystem 
##			uses the same var's.
##############################################################
## MOD History: 
## 
##   2oo3-o7-o7 - Version 1.0.0
##      - First release.         
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################

En nu krijg ik deze error als ik een topic bekijk:

Code: Selecteer alles

 
Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_money' in 'field list'

SELECT u.username, u.user_points, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, u.user_allow_viewonline, u.user_session_time, u.user_birthday, u.user_next_birthday_greeting, u.user_gender, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid, u.user_money FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 237 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 422
File : /usr/local/psa/home/vhosts/mr-ski.nl/subdomains/timtheweb/httpdocs/phpBB2/viewtopic.php 

En deze als ik naar de ledenlijst ga:

Code: Selecteer alles

 
Could not query users

DEBUG MODE

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

SELECT username, user_points, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, user_money FROM phpbb_users WHERE user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50

Line : 168
File : /usr/local/psa/home/vhosts/mr-ski.nl/subdomains/timtheweb/httpdocs/phpBB2/memberlist.php 

Wat betekent dit en waar moet ik het zoeken?

Dit deel uit de SQL update is gedaan:

Code: Selecteer alles

ALTER TABLE `phpbb_ranks` ADD `user_money` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL ;

[WebSiteNet]

Probeer dit ook uit te voeren. Weet je zeker dat wat je gaf de query was?

Code: Selecteer alles

ALTER TABLE `phpbb_users` ADD `user_money` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL ; 

[cartoontje]

Jep!

Code: Selecteer alles

#
#-----[ SQL ]------------------------------------------ 
# 

INSERT INTO phpbb_config VALUES ('use_allowance_system', '0');
INSERT INTO phpbb_config VALUES ('use_rank_reward_system', '0');
INSERT INTO phpbb_config VALUES ('use_forum_reward_system', '0');
INSERT INTO phpbb_config VALUES ('pm_reward', '0');
INSERT INTO phpbb_config VALUES ('pm_charge', '0');
INSERT INTO phpbb_config VALUES ('nt_reward', '0');
INSERT INTO phpbb_config VALUES ('nt_charge', '0');
INSERT INTO phpbb_config VALUES ('pr_reward', '0');
INSERT INTO phpbb_config VALUES ('pr_charge', '0');
INSERT INTO phpbb_config VALUES ('allowance_payday', 'daily');
INSERT INTO phpbb_config VALUES ('allowance', '0');
INSERT INTO phpbb_config VALUES ('default_money', '0');
INSERT INTO phpbb_config VALUES ('money_name', 'Tokens');
INSERT INTO phpbb_config VALUES ('sig_charge', '0');
INSERT INTO phpbb_config VALUES ('last_payday', '0');

ALTER TABLE `phpbb_ranks` ADD `rank_reward` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL ;

##
## NOTE :: 	The next SQL command will return an error if you have already installed
##		Xore's MoneySystem. If you have installed the MoneySystem then please
##		skip this SQL command since you already have this field installed.
##

ALTER TABLE `phpbb_ranks` ADD `user_money` INT( 11 ) UNSIGNED DEFAULT '0' NOT NULL ;

Maar ik ga het ff proberen!

Edit: And Websitenet saves the day again, thanks!

[WebSiteNet]

ps: Het is een fout in de mod. Mijn query is de goede.