Jump to content

Download: Classifieds


Andy Millne
 Share

Recommended Posts

File Name: Classifieds
File Submitter: AndyMillne
File Submitted: 07 Apr 2010
File Updated: 14 Sep 2010
File Category: Applications

Classifieds allows your community members to list for sale and wanted adverts.

Features include;

  • Image attachments.
  • Custom fields.
  • Hierarchical categories.
  • "Ask Advertiser a Question"
  • Category Subscriptions.
  • Search Engine Optimised fURLs


Click here to download this file
Link to comment
Share on other sites

There are no file edits required. The only thing you will need to do post installation is to set up your group permissions.

Are you installing it on a clean install or do you have some other mods already installed? I don't think there is a general problem as several different users have previously tested the app. It sounds like it could be specific to your setup. That being said I'll defiantely try and work with you to get you up and running. I need more info from you though, when is the IPS driver error appearing. What steps did you take during install?

Link to comment
Share on other sites

Thanks for beeing nice.

I have IP.Board 3.0.5, tested on localhost, and the following applications enabled:

Root Applications

IPS Add Ons

And the following hooks:

  • (SOS30) Ver Quem Reputou os Posts v1.0.0
  • [EN30] Ajax Fast Reply v1.0.4
  • (DP30) Custom Meta Tags
  • (DP30) Similar Topics
  • Who's Chatting
  • (IM) Members Online Today
  • Recent Posts
  • Status Updates
  • Topic Google Ads

When I install IP.Classifieds, IP.Board Set Up Utility reports no errors. Right after I install it, I get the following error on board index:


localhost Driver Error
There appears to be an error with the database.If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again.

You can try to refresh the page by clicking here






On board index I get that error; however, I can access topics by typing the address on the browser. I also get the error message above when I click on "Classifieds" tab. If I uninstall Classifieds, then everyhting goes back to normal.


Is there anything I can try?

Edited by Michael
Removed links to localhost images, was throwing errors for some folks
Link to comment
Share on other sites

Thanks Stoo2000,

Here is the content of the file:




===================================================
Date: Thu, 08 Apr 2010 14:45:01 +0000
Error Number: 1054
Error: Unknown column 'seo_title' in 'field list'
IP Address: 127.0.0.1
Page: /305/
Debug: array (
1 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305ips_kernelclassDb.php',
'line' => 1019,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hookscfdsLatestAdsSidebarHook_80a4c969a8d027ff78246750015b5f2f.php',
'line' => 27,
'function' => 'getNode',
'class' => 'classifieds_categories',
),
5 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2990,
'function' => 'getOutput',
'class' => 'cfdsLatestAdsSidebarHook',
),
6 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2315,
'function' => 'templateHooks',
'class' => 'output',
),
7 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplicationsforumsmodules_publicforumsboards.php',
'line' => 120,
'function' => 'sendOutput',
'class' => 'output',
),
8 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hooksdp30CustomMetaTags_e0e9d43939d759fe4c5924076b2049af.php',
'line' => 69,
'function' => 'doExecute',
'class' => 'public_forums_forums_boards',
),
9 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesbaseipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'dp30CustomMetaTags',
),
)
mySQL query error: SELECT category_id,parent_id,sort_order,name,lft,rgt,depth,seo_title FROM ibf_classifieds_categories WHERE category_id = 1
===================================================
Date: Thu, 08 Apr 2010 14:47:11 +0000
Error Number: 1054
Error: Unknown column 'seo_title' in 'field list'
IP Address: 127.0.0.1
Page: /305/
Debug: array (
1 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305ips_kernelclassDb.php',
'line' => 1019,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hookscfdsLatestAdsSidebarHook_80a4c969a8d027ff78246750015b5f2f.php',
'line' => 27,
'function' => 'getNode',
'class' => 'classifieds_categories',
),
5 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2990,
'function' => 'getOutput',
'class' => 'cfdsLatestAdsSidebarHook',
),
6 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2315,
'function' => 'templateHooks',
'class' => 'output',
),
7 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplicationsforumsmodules_publicforumsboards.php',
'line' => 120,
'function' => 'sendOutput',
'class' => 'output',
),
8 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hooksdp30CustomMetaTags_e0e9d43939d759fe4c5924076b2049af.php',
'line' => 69,
'function' => 'doExecute',
'class' => 'public_forums_forums_boards',
),
9 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesbaseipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'dp30CustomMetaTags',
),
)
mySQL query error: SELECT category_id,parent_id,sort_order,name,lft,rgt,depth,seo_title FROM ibf_classifieds_categories WHERE category_id = 1
===================================================
Date: Thu, 08 Apr 2010 14:47:13 +0000
Error Number: 1054
Error: Unknown column 'seo_title' in 'field list'
IP Address: 127.0.0.1
Page: /305/
Debug: array (
1 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305ips_kernelclassDb.php',
'line' => 1019,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hookscfdsLatestAdsSidebarHook_80a4c969a8d027ff78246750015b5f2f.php',
'line' => 27,
'function' => 'getNode',
'class' => 'classifieds_categories',
),
5 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2990,
'function' => 'getOutput',
'class' => 'cfdsLatestAdsSidebarHook',
),
6 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2315,
'function' => 'templateHooks',
'class' => 'output',
),
7 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplicationsforumsmodules_publicforumsboards.php',
'line' => 120,
'function' => 'sendOutput',
'class' => 'output',
),
8 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hooksdp30CustomMetaTags_e0e9d43939d759fe4c5924076b2049af.php',
'line' => 69,
'function' => 'doExecute',
'class' => 'public_forums_forums_boards',
),
9 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesbaseipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'dp30CustomMetaTags',
),
)
mySQL query error: SELECT category_id,parent_id,sort_order,name,lft,rgt,depth,seo_title FROM ibf_classifieds_categories WHERE category_id = 1
===================================================
Date: Thu, 08 Apr 2010 14:47:14 +0000
Error Number: 1054
Error: Unknown column 'seo_title' in 'field list'
IP Address: 127.0.0.1
Page: /305/
Debug: array (
1 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305ips_kernelclassDb.php',
'line' => 1019,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hookscfdsLatestAdsSidebarHook_80a4c969a8d027ff78246750015b5f2f.php',
'line' => 27,
'function' => 'getNode',
'class' => 'classifieds_categories',
),
5 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2990,
'function' => 'getOutput',
'class' => 'cfdsLatestAdsSidebarHook',
),
6 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesclassesoutputpublicOutput.php',
'line' => 2315,
'function' => 'templateHooks',
'class' => 'output',
),
7 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplicationsforumsmodules_publicforumsboards.php',
'line' => 120,
'function' => 'sendOutput',
'class' => 'output',
),
8 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305hooksdp30CustomMetaTags_e0e9d43939d759fe4c5924076b2049af.php',
'line' => 69,
'function' => 'doExecute',
'class' => 'public_forums_forums_boards',
),
9 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesbaseipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'dp30CustomMetaTags',
),
)
mySQL query error: SELECT category_id,parent_id,sort_order,name,lft,rgt,depth,seo_title FROM ibf_classifieds_categories WHERE category_id = 1
===================================================
Date: Thu, 08 Apr 2010 14:47:39 +0000
Error Number: 1054
Error: Unknown column 'seo_title' in 'field list'
IP Address: 127.0.0.1
Page: /305/classifieds/
Debug: array (
1 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305ips_kernelclassDb.php',
'line' => 1019,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplications_addonotherclassifiedssourcesclassCategories.php',
'line' => 85,
'function' => 'getNode',
'class' => 'classifieds_categories',
),
5 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplications_addonotherclassifiedsmodules_publiccorecore.php',
'line' => 113,
'function' => 'getDescendants',
'class' => 'classifieds_categories',
),
6 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplications_addonotherclassifiedsmodules_publiccorecore.php',
'line' => 94,
'function' => 'index',
'class' => 'public_classifieds_core_core',
),
7 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesbaseipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'public_classifieds_core_core',
),
)
mySQL query error: SELECT category_id,parent_id,sort_order,name,lft,rgt,depth,seo_title FROM ibf_classifieds_categories WHERE category_id = 1
===================================================
Date: Thu, 08 Apr 2010 14:47:54 +0000
Error Number: 1054
Error: Unknown column 'seo_title' in 'field list'
IP Address: 127.0.0.1
Page: /305/classifieds/
Debug: array (
1 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305ips_kernelclassDb.php',
'line' => 1019,
'function' => 'query',
'class' => 'db_driver_mysql',
),
4 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplications_addonotherclassifiedssourcesclassCategories.php',
'line' => 85,
'function' => 'getNode',
'class' => 'classifieds_categories',
),
5 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplications_addonotherclassifiedsmodules_publiccorecore.php',
'line' => 113,
'function' => 'getDescendants',
'class' => 'classifieds_categories',
),
6 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminapplications_addonotherclassifiedsmodules_publiccorecore.php',
'line' => 94,
'function' => 'index',
'class' => 'public_classifieds_core_core',
),
7 =>
array (
'file' => 'C:Arquivos de programasApache GroupApache2htdocs305adminsourcesbaseipsController.php',
'line' => 291,
'function' => 'doExecute',
'class' => 'public_classifieds_core_core',
),
)
mySQL query error: SELECT category_id,parent_id,sort_order,name,lft,rgt,depth,seo_title FROM ibf_classifieds_categories WHERE category_id = 1

Link to comment
Share on other sites


we meet same errors too and forum index page is down


There appears to be an error with the database.



clickec "manage categories" is showing errors too




With regard to your board index, it looks like the classifieds app does also come with a board index hook. If so, does it get your board index online again when disabling the hooks that come with the classified app?
Link to comment
Share on other sites

probably the css file didn't export properly or an old one is still in the package.


Here's the contents of my dev copy which should include all the most recent CSS changes.

#item_details_table { width: 20px; float:right; } #sidebar { float:left; width:200px; } .sidebar_nav ul { font-size: 0.9em; -moz-border-radius: 0 0 10px 10px; -webkit-border-bottom-left-radius: 10px; -webkit-border-bottom-right-radius: 10px; padding: 5px 10px; } .sidebar_nav li { margin: 2px 0; text-align: left; } .sidebar_nav li a { background: #d5dde5; text-decoration: none; -moz-border-radius: 4px; -webkit-border-radius: 4px; padding: 5px 7px; display: block; } .sidebar_tree { font-size:1.1em; } .sidebar_tree ul { font-size: 0.9em; /*padding: 5px 0px 0px 10px;*/ } .sidebar_tree li { margin: 2px 0; text-align: left; padding:0.4em 0 0.3em 0.5em; } .sidebar_tree li a { padding-left: 0.2em; text-decoration: none; /* padding: 5px 0px 5px 0px; */ } #sidebar .general_box { margin-bottom:15px; } #category_index { padding:10px; overflow: hidden; } #category_index ul { margin:0; padding:0; list-style-type:none; font-size: 1.1em; } #category_index ul li { font-weight:bold; float:left; width:15.5em; padding:0.4em 1em; } #category_index ul li ul li { font-weight:normal; font-size: 0.9em; padding:0.4em 1em; } #category_index ul li ul li ul li { font-weight:normal; font-size: 0.8em; padding:0.3em 1em; } .category_list li { display: inline; padding: 0 10px; } .highlight_image { padding: 8px; } #intro_text { padding: 10px; margin-bottom:10px; border: 1px solid #CCC; } .col_thumb { width: 85px; } .col_expiry { width: 140px; } .right_column { margin-left: 220px; } .price_box { padding: 15px; margin-top: 10px; margin-bottom: 10px; width: 200px; background: #EEE; font-size:1.2em; font-weight:bold; } .price_box_small { padding: 5px; margin-top: 2px; margin-bottom: 5px; font-size:1.1em; font-weight:bold; } .core_info_wrap { padding: 10px; } .purchase_box { margin: 6px 0 6px 0; background: #EEE; font-weight:bold; padding: 12px; text-align:center; } .purchase_box a { text-decoration: none; } #profile_overview .reputation { float: none; text-align: center; font-weight: normal; margin: 6px 0; } #profile_overview .reputation .number { font-size: 1.1em; font-weight: bold; } #profile_overview .reputation .title, #profile_overview .reputation .image { font-size: 0.9em; display: block; }













































































Link to comment
Share on other sites


Hello Andy


where(which file) should we replace or add or edit please?




You'll need to go in the ACP to Look & feel -> Your skin -> css -> ipb_classifieds.css and replace the contents with what I have posted above.

The CSS on my dev copy wasn't exported during the build so it is still an old CSS file thats being used from a previous test version.
Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...