Cash MOD problems

Wondering why that MOD you have won't install correctly? Let's take a look
Forum rules
DO NOT give out any FTP passwords to anyone! There is no reason to do so! If you need help badly enough, create a temporary FTP account that is restricted to only the files that you need help with and give the information for that. Giving out FTP information can be very dangerous!
Locked
bigone
Registered User
Posts: 1
Joined: Tue Mar 28, 2006 11:56 am

Cash MOD problems

Post by bigone »

Hey, I've got problems installing the latest Cash mod, it says Easymod compatible, but it just won't work...

Code: Select all

Error Detail
 
Critical Error

FIND FAILED&#58 In file [posting.php] could not find&#58

$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, u.user_sig_bbcode_uid' &#58 '';

MOD script line #257 &#58&#58 FAQ &#58&#58 Report
 
MOD Data
MOD Title&#58 	Cash Mod     2.2.3     cm_install_223.txt
Author&#58 	Xore     [email protected]     Robert Hetzler     http&#58//www.xore.ca
Processed Themes&#58 	subSilver; NoseBleed
Processed Languages&#58 	korean; norwegian; serbian; polish; kurdish; slovak; english; russian; uighur; estonian; german_sie; spanish; chinese_simplified; macedonian; azerbaijani; romanian; spanish_argentina; portuguese_brazil; lithuanian; turkish; ukrainian; japanese; portuguese; albanian; hungarian; romanian_no_diacritics; mongolian; catalan; bosnian; czech; dutch; croatian; greek; russian_tu; serbian_cyrillic; welsh; asturian; indonesian; italian; bulgarian; chinese_traditional_taiwan; arabic; galego; german; french; hebrew; icelandic; thai
Files Edited&#58 	3
Commands Processed&#58 	22
Unprocessed Commands&#58 	0

rip2roar
Registered User
Posts: 13
Joined: Fri Mar 31, 2006 7:55 pm

Re: Cash MOD problems

Post by rip2roar »

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" : '';

MOD script line #253 :: FAQ :: Report
Same :?

chesspro
Registered User
Posts: 2
Joined: Mon Feb 20, 2006 9:24 pm

Re: Cash MOD problems

Post by chesspro »

Yes, I found the same problem when using easy mod...

But I read from the phpbb forums for the Cash Mod, and it tells you how to fix it.

First, run that sql installer...which is that php file that's called sql_install.php or something like that. But before you do this, you have to be logged into your website as the admin...

Next, go to posting.php, and find a line that looks the closest to that line the EasyMod thing couldn't find. Then, copy and paste that line into that cm_install_221.txt, the same line it said it couldn't fine...

For me, I replaced(in the cm_install_221.txt file)

$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" : '';

with

$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, u.user_sig_bbcode_uid' : '';


After you do that, the whole thing should work. After that step, the Easy MOd should have no problem installing it. It will say sql error or something like that, but just continue. For me, it worked perfectly after I copied and replaced that file.

Nightrider
Registered User
Posts: 7219
Joined: Tue Nov 16, 2004 8:54 pm
Location: Florida, US
Contact:

Re: Cash MOD problems

Post by Nightrider »

Yes, chesspro is right but for this line, you don't have to provide so much detail. EM can use any unique value to find the appropriate location specified by the MOD. Most MOD authors provide far too much detail in their MODs making them less likely to install easily on a great many boards...

This is what I would do:

OPEN
cm_install_222.txt

FIND

Code: Select all

# 
#-----[ 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" &#58 '';
REPLACE WITH

Code: Select all

# 
#-----[ FIND ]------------------------------------------ 
# 
		$select_sql =
Save the MOD file and upload it back to it's MOD sub-folder in admin/mods and try running it again using EM...

Image

rip2roar
Registered User
Posts: 13
Joined: Fri Mar 31, 2006 7:55 pm

Re: Cash MOD problems

Post by rip2roar »

Proposed Database Alterations for your mysql Database Allow

SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually

The following error occured:

Error:
Unknown SQL command ";", statement: 1

SQL:
:|
It says it is installed but this happened when doing so.

chesspro
Registered User
Posts: 2
Joined: Mon Feb 20, 2006 9:24 pm

Re: Cash MOD problems

Post by chesspro »

You can ignore that, and just continue, as long as you make sure you have edited the database manually, or ran this file: sql_install.php

That php file should automatically update the database for you.

Good luck! :D

rip2roar
Registered User
Posts: 13
Joined: Fri Mar 31, 2006 7:55 pm

Re: Cash MOD problems

Post by rip2roar »

Working fine :D
Thanks for all the help

Locked