Database problem

  • Resolved hkullas

    (@hkullas)


    13 years, 6 months ago

    Hello!

    I try to create a new category, forum, anything — it won’t let me. At first I wasn’t sure why it’s giving me these errors but I tried to link the “wp-bulletin-board” to one of my ‘Pages’ and I loaded the page. Then it all cleared up on my head; it hasn’t created the database tables. I logged in to my phpMyAdmin and verified that.

    I’ve tried to deactivate and activate the plugin many times manually (uploading the content from .zip file to “/wp-content/plugins/”) and automaticly (via admin control panel and ‘Plugins’).

    Any ideas? I tried to search similiar problems with this plugin but couldn’t find any. I also couldn’t find any information on how many and what kind of tables ‘wp-bulletin-board’ is using.

    Any help is appreciated.

    Sincerely,
    HKullas

    http://ww.wp.xz.cn/extend/plugins/wp-bulletin-board/

Viewing 11 replies - 1 through 11 (of 11 total)
  • Plugin Author codebycarter

    (@codebycarter)

    13 years, 6 months ago

    That’s the first I’ve heard of this, very strange.

    You’re definitely using WordPress version 3.4.2? What plugins are you running alongside WPBB? Did you deactivate and then delete WPBB and then install and activate? Could you post a link to your wordpress site here or via email? (me at codebycarter.com)

    Thanks

    Thread Starter hkullas

    (@hkullas)

    13 years, 6 months ago

    I’ve sent you an e-mail.

    Yes, I’m definetily using 3.4.2 (checked that it doesn’t have any updates available).

    I’m also running ‘Contact Form 7’, ‘Quick Chat’, ‘Teamspeak3 Webviewer for WordPress’ and ‘WP-UserOnline’.

    I ave deactivated WPBB and deleted it as well. Although, for some reasons when I try to install it again and activate it it loads the previous settings I used before. Is that normal?

    Much appreciated!

    Plugin Author codebycarter

    (@codebycarter)

    13 years, 6 months ago

    hkullas got it working after switching from LAMP which was probably causing the problem. Will be looking into this. Will mark this as read but any one can reply here if they have anything to add.

    Thanks

    P.Effrem

    (@peffrem)

    13 years, 3 months ago

    I am having the same problem using WPBB and WordPress 3.4.2. I can create forums but not categories. What is the cure?

    Thanks

    Plugin Author codebycarter

    (@codebycarter)

    13 years, 3 months ago

    Hey P.Effrem,

    Are you receiving a blank page or does it say something like “Error creating category” when you try to create a category? Categories, Forums and Sub forums use the same database table so not sure why categories won’t work, could you email me an admin login? (me at codebycarter.com)

    Thanks

    P.Effrem

    (@peffrem)

    13 years, 3 months ago

    I don’t enter anything for the “Order” field just the Name and then press, Create Category and then the error message “Error creating category, please try again!” is displayed in pink. Is there anything else I should check?

    Thanks

    Plugin Author codebycarter

    (@codebycarter)

    13 years, 3 months ago

    Yes in wp-bulletin-board/php/admin/wpbb-admin-categories.php at the top of the file find:

    global $wpdb;

    Add after:
    $wpdb->show_errors();

    Then try to create a category again and paste the error message here 🙂

    Thanks again.

    P.Effrem

    (@peffrem)

    13 years, 3 months ago

    I inserted the above code and got the following error:

    WordPress database error: [Field ‘description’ doesn’t have a default value]
    INSERT INTO wp_wpbb_categories (name,forum,subforum,view,read,post,reply,edit,lock,delete,sticky,order) VALUES (‘test-category’,’0′,’0′,”,”,”,”,”,”,”,”,’0′)

    Now what do you suggest?

    Thanks

    Plugin Author codebycarter

    (@codebycarter)

    13 years, 3 months ago

    Thanks, ok, you could try this (in phpMyAdmin, run this SQL Query)

    http://www.pastebin.com/5TZr0dds

    Please let me know if you need help with this. Can do it for you or guide you on how to do it yourself in more detail. Better to send me an email, again its me at codebycarter.com

    Thanks

    P.Effrem

    (@peffrem)

    13 years, 3 months ago

    That did the trick. Now I can define Categories without any errors. Will you be releasing a code update?

    Thanks

    volvo_owmer

    (@volvo_owmer)

    12 years, 8 months ago

    Hello

    Can you show that SQL Query, I have problem to create category….

Viewing 11 replies - 1 through 11 (of 11 total)

The topic ‘Database problem’ is closed to new replies.