[2.0.18] Cash Mod

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
1036
66%
Very Good
239
15%
Good
121
8%
Fair
36
2%
Poor
126
8%
 
Total votes: 1558

jaded_marla
Registered User
Posts: 5
Joined: Fri Dec 08, 2006 4:55 am

Fatal Error

Post by jaded_marla » Fri Dec 08, 2006 5:04 am

Hi! I did a manual install following the instructions. But, now when I click on a member name or click on a thread I get this error:
Fatal error: Class 'Template' not found in /usr421/home/a/r/armmada/public_html/forum/phpBB2/includes/classes_cash.php on line 40
Last edited by jaded_marla on Fri Dec 08, 2006 3:25 pm, edited 1 time in total.

dynamok
Registered User
Posts: 21
Joined: Tue Oct 31, 2006 10:54 pm
Location: Minneapolis
Contact:

Post by dynamok » Fri Dec 08, 2006 5:22 am

Wanted to see if I can get some help. Installed the mod fine, but I'm getting this error when I to memberlist:

Code: Select all

SQL Error : 1052 Column 'user_id' in field list is ambiguous

SELECT username, phpbb_users.user_hryvnia, user_rubl, user_id, u_up_total, u_down_total, user_viewemail, user_posts, user_regdate, user_from, user_from_flag, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users LEFT JOIN phpbb_bt_users ON phpbb_users.user_id = phpbb_bt_users.user_id WHERE phpbb_users.user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50

Line : 156
File : memberlist.php
I created 2 currencies in admin hryvnia & rubl.

User avatar
Jackanape
Registered User
Posts: 1076
Joined: Wed Oct 13, 2004 6:01 am
Location: Capitol of the Great State of New York
Name: Jack Drury
Contact:

Post by Jackanape » Fri Dec 08, 2006 5:29 am

K34nu wrote: Should I just get an "Posting.php" from a new copy of PhpBB?


No, you would lose the changes you've already made, and all your other mods would get screwed up.

When you run into this problem, try searching for PARTS of the line the mod is looking for. Often, especially with modded SQL queries, you've already added something that prevents you from finding that line. A partial search will locate it for you.

Once you're sure it's the right line, manually make the changes.
~Extending the rule of meticulous exactitude to exaspirating punctillio...still.~
Treat your phpBB like a member of the family--Update and MOD her by hand, with HTML-Kit
: : Wanna Talk Poker? : : Image : :

jaded_marla
Registered User
Posts: 5
Joined: Fri Dec 08, 2006 4:55 am

Post by jaded_marla » Fri Dec 08, 2006 5:30 am

When I went to Cash Admin (in the Admin panel at my forums) I got this error:
Fatal error: Call to a member function sql_query() on a non-object in /usr421/home/a/r/armmada/public_html/forum/phpBB2/includes/functions_cash.php on line 659

Instead of posting all the coding here like my other error, you can click here to see the coding (I put line 659 in bold):
http://www.angel-lands.net/functions_cash.html

User avatar
Scriptmaster10
Registered User
Posts: 107
Joined: Mon Aug 29, 2005 5:47 pm
Location: The Heart of England

Post by Scriptmaster10 » Fri Dec 08, 2006 7:39 am

Thanks a bundle everyone for helping me....

I know not to use this community for cashmod problems again.

Regards,

User avatar
karlsemple
Former Team Member
Posts: 39802
Joined: Mon Nov 01, 2004 8:54 am
Location: Hereford, UK
Contact:

Post by karlsemple » Fri Dec 08, 2006 7:50 am

Scriptmaster10 wrote: Thanks a bundle everyone for helping me....

I know not to use this community for cashmod problems again.

Regards,



Dare I ask why not? you were asked to check something and never replied..... :?
Image

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51888
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Fatal Error

Post by Brf » Fri Dec 08, 2006 12:22 pm

jaded_marla wrote: Hi! I did a manual install following the instructions. But, now when I click on a member name or click on a thread I get this error:
Fatal error: Class 'Template' not found in /usr421/home/a/r/armmada/public_html/forum/phpBB2/includes/classes_cash.php on line 40


Please remove that large posting. This error is caused by having the edit to common.php in the wrong place.
It should look like this:

Code: Select all

include($phpbb_root_path . 'includes/constants.'.$phpEx);
include($phpbb_root_path . 'includes/template.'.$phpEx);
include($phpbb_root_path . 'includes/sessions.'.$phpEx);
include($phpbb_root_path . 'includes/auth.'.$phpEx);
include($phpbb_root_path . 'includes/functions.'.$phpEx);
include($phpbb_root_path . 'includes/db.'.$phpEx);

if ( defined('IN_CASHMOD') )
{
	include($phpbb_root_path . 'includes/functions_cash.'.$phpEx);
}
That will also fix this error:
jaded_marla wrote: When I went to Cash Admin (in the Admin panel at my forums) I got this error:
Fatal error: Call to a member function sql_query() on a non-object in /usr421/home/a/r/armmada/public_html/forum/phpBB2/includes/functions_cash.php on line 659

http://www.angel-lands.net/functions_cash.html
Last edited by Brf on Fri Dec 08, 2006 12:32 pm, edited 1 time in total.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51888
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf » Fri Dec 08, 2006 12:27 pm

dynamok wrote: Wanted to see if I can get some help. Installed the mod fine, but I'm getting this error when I to memberlist:

Code: Select all

SQL Error : 1052 Column 'user_id' in field list is ambiguous

SELECT username, phpbb_users.user_hryvnia, user_rubl, user_id, u_up_total, u_down_total, user_viewemail, user_posts, user_regdate, user_from, user_from_flag, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users LEFT JOIN phpbb_bt_users ON phpbb_users.user_id = phpbb_bt_users.user_id WHERE phpbb_users.user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50

Line : 156
File : memberlist.php
I created 2 currencies in admin hryvnia & rubl.


This error is caused by a conflict with another mod. You can fix it like this:

in includes/classes_cash.php

Look for:

Code: Select all

	$insertpoint = strpos($sql,'user_id');
and replace it with this:

Code: Select all

	$insertpoint = strpos($sql,'username');

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51888
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf » Fri Dec 08, 2006 12:29 pm

karlsemple wrote:
Scriptmaster10 wrote:Thanks a bundle everyone for helping me....

I know not to use this community for cashmod problems again.

Regards,



Dare I ask why not? you were asked to check something and never replied..... :?


Yes:
Brf wrote: I was asking if there was anything in usercp_viewprofile that might be blanking out CASH, or if you have even put the proper cash edit in there.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51888
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf » Fri Dec 08, 2006 12:47 pm

K34nu wrote: Critical Error

FIND FAILED: In file [posting.php] could not find:

$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';


If you have any mods to Polls, that could be a little messed up. The line it is looking for is in the "poll_delete" selection

dynamok
Registered User
Posts: 21
Joined: Tue Oct 31, 2006 10:54 pm
Location: Minneapolis
Contact:

Post by dynamok » Fri Dec 08, 2006 2:15 pm

Brf wrote:
dynamok wrote:Wanted to see if I can get some help. Installed the mod fine, but I'm getting this error when I to memberlist:

Code: Select all

SQL Error : 1052 Column 'user_id' in field list is ambiguous

SELECT username, phpbb_users.user_hryvnia, user_rubl, user_id, u_up_total, u_down_total, user_viewemail, user_posts, user_regdate, user_from, user_from_flag, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM phpbb_users LEFT JOIN phpbb_bt_users ON phpbb_users.user_id = phpbb_bt_users.user_id WHERE phpbb_users.user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50

Line : 156
File : memberlist.php
I created 2 currencies in admin hryvnia & rubl.


This error is caused by a conflict with another mod. You can fix it like this:

in includes/classes_cash.php

Look for:

Code: Select all

	$insertpoint = strpos($sql,'user_id');
and replace it with this:

Code: Select all

	$insertpoint = strpos($sql,'username');


BRF, you're the best! I can't believe it was such a quick fix, thank you!

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51888
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Post by Brf » Fri Dec 08, 2006 2:27 pm

dynamok wrote: BRF, you're the best! I can't believe it was such a quick fix, thank you!


Actually, I remembered this from a few months ago and how to fix it...

If you would have done a search on this forum only, using the keyword "ambiguous", and searching for "posts", rather than topics, you would have found the answer quickly.

SKLiF
Registered User
Posts: 37
Joined: Tue Feb 03, 2004 7:30 am

Post by SKLiF » Fri Dec 08, 2006 3:03 pm

Can anyone remind mod to take cash for posting a new top?

So that if you want to start a new topic, you have to pay some cash :)
thank you!

jaded_marla
Registered User
Posts: 5
Joined: Fri Dec 08, 2006 4:55 am

Post by jaded_marla » Fri Dec 08, 2006 3:40 pm

Thanks for the help but now I have run into another error. Knowing me I just did something wrong.

Ok, I think I was supposed to edit the file "common.php". Here is what lines 177-192 look like now:

177 include($phpbb_root_path . 'includes/constants.'.$phpEx);
178 include($phpbb_root_path . 'includes/template.'.$phpEx);
179 include($phpbb_root_path . 'includes/sessions.'.$phpEx);
180 include($phpbb_root_path . 'includes/auth.'.$phpEx);
181 include($phpbb_root_path . 'includes/functions.'.$phpEx);
182 include($phpbb_root_path . 'includes/db.'.$phpEx);
183 if ( defined('IN_CASHMOD') )
184 {
185 include($phpbb_root_path . 'includes/functions_cash.'.$phpEx);
186}
187
188 if( !defined("PHPBB_INSTALLED") )
189 {
190 header('Location: ' . $phpbb_root_path . 'install/install.' . $phpEx);
191 exit;
192}


OK. So, now when I go to my forums I get this error instead of my forums opening up:
Fatal error: Class 'sql_db' not found in /usr421/home/a/r/armmada/public_html/forum/phpBB2/includes/db.php on line 60

Lines 59-64 in the "includes/db.php" file look like this:
59 // Make the database connection.
60 $db = new sql_db($dbhost, $dbuser, $dbpasswd, $dbname, false);
61 if(!$db->db_connect_id)
62 {
63 message_die(CRITICAL_ERROR, "Could not connect to the database");
64 }

User avatar
Jackanape
Registered User
Posts: 1076
Joined: Wed Oct 13, 2004 6:01 am
Location: Capitol of the Great State of New York
Name: Jack Drury
Contact:

Post by Jackanape » Fri Dec 08, 2006 5:54 pm

It there are some serious gaps in the installation of Cashmod...or, at best, conflicts with pre-existing mods.

I think you will save yourself a lot of time just going to your back up from before you installed cashmod, and going to it by hand, a step at a time. It may seem like it will take a long time, but it will save you headache grief and time that you might spend trying to solve these little problems.

If you don't have a good text editor that helps you with line numbers, etc, try Acehtml freeware, it's linked in my sig. makes this sort of job very easy...
~Extending the rule of meticulous exactitude to exaspirating punctillio...still.~
Treat your phpBB like a member of the family--Update and MOD her by hand, with HTML-Kit
: : Wanna Talk Poker? : : Image : :

Post Reply

Return to “[2.0.x] MOD Database Releases”