 | Classified Ads MOD problem |  |
 Posted: 05/19/2007 1:55 PM |
 |
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
 |
|
|
|
Joined: Apr 01, 2007
Local time: 12:27 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
 |
Hi Nightrider,
I have installed Classified Ads MOD past 1 week on live as well as Test board and after that installed many other MODs so cannot delete this now. I didn't test it deeply and one of my user told me the bug which I am confused on how to fix that. I need to fix at live board and you may tell me how to fix so I will myself fix at test board also later.
When we create any post in classified and try to look at our any ad like this http://www.funwadi.com/forum/ads_item.php?id=2 so it says
| Code:
|
General Error
Error reading category table
DEBUG MODE
SELECT * FROM phpbb_ads_categories WHERE cat_category = 'Business & Commercial' AND cat_sub_category = 'Product for Sale'
Line : 115
File : ads_item.php
|
The download link is
| Code:
|
|
http://www.phpca.net/phpCA-0.5.6.zip
|
  |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/19/2007 6:44 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:27 AM
Location: St Pete, FL
|
|
|
|
|
|
You don't have any Category named Business & Commercial. What's stored in your phpbb_ads_categories table is Business & Commercials, so your query would return an empty set, which is probably what is being reported here even though it isn't clear about it...
 |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 2:15 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 12:27 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Ohh! So what i have to do now |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 2:43 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 12:27 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| I renamed 1st Business & Commercials to Business & Commercials through phpMyAdmin. Do you want me to edit all such categories or there is any easy way to edit/fix all |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 2:44 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:27 AM
Location: St Pete, FL
|
|
|
|
|
|
Where do you create these records? You need to correct the Category name so that it matches what is being requested. Since I can't get into your ACP, I can't really see what you do with these...
|
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 2:47 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 12:27 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Ohh Sorry. I forgot to tell you this also !!! I am so dumb. The password to enter ACP is same what is for FTP password and username is ab |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 2:52 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:27 AM
Location: St Pete, FL
|
|
|
|
|
|
| abdulbasit wrote:
|
|
I renamed 1st Business & Commercials to Business & Commercials through phpMyAdmin. Do you want me to edit all such categories or there is any easy way to edit/fix all
|
I can edit them directly in your database easy enough. My concern is whether the code is converting & to & and will continue causing problems unless you avoid the ampersand. Also, there was an extra s at the end of Commercial. I didn't know whether you wanted it to say Commercials or Commercial...
|
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 2:59 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 12:27 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
Ah, that will be easy than. Yeah, i don't know how it is making & to &
I think that "s" was from before because in other categories like Vehicles for Sale, Vehicles Wanted don't have automatic "s" at the end so I think only the problem is of & & |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 3:09 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 4:27 AM
Location: St Pete, FL
|
|
|
|
|
|
Ok, I corrected the problem in the code, like this:
OPEN
admin/admin_ads_categories.php
FIND
| Code:
|
$category = str_replace("\'", "''", $category);
$sub_category = str_replace("\'", "''", $sub_category);
|
AFTER, ADD
| Code:
|
$category = str_replace("&'", "&", $category);
$sub_category = str_replace("&'", "&", $sub_category);
|
This will convert the ampersand back to & before it runs the query. It works now...
 |
|
|
|
|
| Back to Top |
|
|
| Re: Classified Ads MOD problem | |
| Posted: 05/20/2007 3:12 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 12:27 PM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
