WordPress.org

Ready to get started?Download WordPress

Forums

Another WordPress Classifieds Plugin
[resolved] Sidebar Widget Posting too many ads (12 posts)

  1. WPElliott
    Member
    Posted 2 years ago #

    I have my sidebar widget to post 3 classified ads. This has been working well. Today, when I check, is posting 10. I have double checked the setting and it does say 3. I recently updated to the latest version. Any ideas?

    http://wordpress.org/extend/plugins/another-wordpress-classifieds-plugin/

  2. awpcp
    Member
    Plugin Author

    Posted 2 years ago #

    Yep, this seems to be a bug in the latest version. We're looking into it ASAP. Thanks for letting me know.

  3. equinestaff
    Member
    Posted 2 years ago #

    Hi, my all in one classifieds competely crashed, the side bar wasn't working so i re installed it, now it comes up with this..WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD is_featured_ad tinyint(1) DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD posterip varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD flagged tinyint(1) DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD disabled_date datetime DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD websiteurl VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER ad_contact_email

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads DROP INDEX titdes

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD FULLTEXT KEY titdes (ad_title,ad_details)

    AWPCP SQL Error Errno: [256] SQLError:(145) Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired
    Query : ALTER TABLE wp_awpcp_ads ADD ad_fee_paid float(7,2) NOT NULL AFTER adterm_id
    Called by line 562 in file /index.php, error in /home/allthing/public_html/wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php at line 27, PHP 5.2.17 (Linux)
    Aborting...

    please let me know also when you get it fixed.

    Thanks..

  4. awpcp
    Member
    Plugin Author

    Posted 2 years ago #

    Hi equinestaff,

    That particular issue requires you or someone that maintains your website to repair the wp_awpcp_ads table. That's not something the plugin can fix per se.

    You're the first report of that particular issue. If you can post it in the main support forum, we can explore this further:

    http://forum.awpcp.com

  5. equinestaff
    Member
    Posted 2 years ago #

    Thanks, i have posted this on the main forum, my other site is also now down- but just on the sibebar http://www.horseandponyads.com.au/

    AWPCP SQL Error Errno: [256] SQLError:(145) Table './horseau_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired
    Query : SELECT count(*) FROM wp_awpcp_ads
    Called by line 318 in file /index.php, error in /home/horseau/public_html/wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php at line 29, PHP 5.2.17 (Linux)
    Aborting...

    not sure if this is the same issue or not.

  6. Juan Ramón Díaz
    Member
    Posted 2 years ago #

    @WPElliott: have you tried OSClass? It's not WordPress based, but it's very similar and easy to use. Furthermore, it's for classifieds only!

  7. awpcp
    Member
    Plugin Author

    Posted 2 years ago #

    Bug is patched. Please download 2.0.5.

  8. equinestaff
    Member
    Posted 2 years ago #

    No luck when i downloaded it come up with

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD is_featured_ad tinyint(1) DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD posterip varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD flagged tinyint(1) DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD disabled_date datetime DEFAULT NULL

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD websiteurl VARCHAR( 500 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER ad_contact_email

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads DROP INDEX titdes

    WordPress database error: [Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired]
    ALTER TABLE wp_awpcp_ads ADD FULLTEXT KEY titdes (ad_title,ad_details)
    AWPCP SQL Error Errno: [256] SQLError:(145) Table './allthing_wrdp1/wp_awpcp_ads' is marked as crashed and should be repaired
    Query : ALTER TABLE wp_awpcp_ads ADD ad_fee_paid float(7,2) NOT NULL AFTER adterm_id
    Called by line 556 in file /wp-admin/plugins.php, error in /home/allthing/public_html/wp-content/plugins/another-wordpress-classifieds-plugin/functions_awpcp.php at line 27, PHP 5.2.17 (Linux)
    Aborting...

  9. WPElliott
    Member
    Posted 2 years ago #

    Works great! Thanks for getting the patch done.

  10. awpcp
    Member
    Plugin Author

    Posted 2 years ago #

    @WPElliot: Good news. :)

    @equinestaff: As I mentioned above, you need to repair the tables in phpMyAdmin or your favorite MySQL tool FIRST. Those errors won't disappear on upgrade until you do.

    Your other option if this is a NEW install only, delete the tables and reinstall AWPCP.

  11. equinestaff
    Member
    Posted 2 years ago #

    Thank you, i have now fixed it.

  12. drhookboxingclub
    Member
    Posted 1 year ago #

    From my experience with AWPCP, heavy modification can crash the software, so becareful what you modify and again make sure you upgrade to the latest wordpress.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic