MyBB Community Forums

Full Version: help on blog system
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hello
im a bit new to mybb and i got myself with a problem..
ive downloaded the blog system plugin and installed in my localhost using wampserver to test it and all went fine.
now when i installed it on the live site it gives me this erros on database.
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'antonio2_ci5clan.mybb_Blog' doesn't exist
Query:
SELECT * FROM mybb_Blog ORDER BY date_posted DESC
i have the blog tables on database and my config.php has the right table prefix
any ideias??
anyone?
no one??? crap...:x
Open ./blog.php and find;
    $query     = $db->query("SELECT * FROM " . TABLE_PREFIX . "Blog ORDER BY date_posted DESC");
    $lines    = $db->num_rows($query);

    $max = 5;
    $num = ($page - 1) * $max;
    $totalpage = ceil($lines/$max) + 1;

    $query     = $db->query("SELECT * FROM " . TABLE_PREFIX . "Blog ORDER BY date_posted DESC LIMIT $num, $max");
and Replace Capital letter B of Blog to small letter b. You've to do the same on line # 40, 91 as well.
thank you for the late but helpfull reply
it worked fine Wink
rep added
@Yaldaram:

Do you know if this Plugin is recommendable ? Because i was looking for something like that and dont want to use external Software like Wordpress just for this.

But i am also careful before I try out a Mod. So if you could tell me something about this plugin, good or bad, i would appreciate it.

Cheers

Wolfseye
I've seen couple of issues in the plugin but I'm unable to track down the issues right now. You may use the plugin at your own risk Smile
Ok, thank you. In that case I will just leave this Mod alone.