must be a mistake with the import tips file you provided (it has great information, but it won't import)

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT `id`, `prob`, `group` FROM pod_tips WHERE `active` IS TRUE ORDER BY `order`, `prob`, `title`;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUE ORDER BY `order`, `prob`, `title`' at line 1
Error Number : 1064
Request Date : Saturday, June 26th 2010 @ 03:35:59 PM
Error Date : Saturday, June 26th 2010 @ 03:35:59 PM
Script : http://xxxxxx.com/admincp/pod_tips.php?do=doimport
Referrer : http://xxxxxxxxx.com/admincp/pod_tips.php?do=import
IP Address : xxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

Tips get added in admincp area, but I'm getting a lot of these db errors when trying to add tips, or view them in the admincp.
Using VB 4.03

I don't think it has to do with the file. The query that gives you problems just reads all the contents of the table to create the datastore (that's why oyou get the error every time you try to add a tip. I guess it has to do with the version of your MySQL server (the error says it's 4.1.22, I never tested with anything under 5.x). Please allow me some time to find a way to find a test instalation of your version.

One question, when you tried the import, the "Check duplicated tips" box was checked?

doesnt matter if duplicated tips box is checked. Tips get imported, can be seen in admincp in tips manager, but still get database error after importing.

Tips don't show in forum, or anywhere, for that matter.


(not sure if Photogallery is messing with that)

Deleting tips gives the same db error. Doing anything with your system gives the same db error:

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT `id`, `prob`, `group` FROM pod_tips WHERE `active` IS TRUE ORDER BY `order`, `prob`, `title`;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUE ORDER BY `order`, `prob`, `title`' at line 1
Error Number : 1064
Request Date : Saturday, June 26th 2010 @ 04:19:18 PM
Error Date : Saturday, June 26th 2010 @ 04:19:18 PM
Script : http://xxxxxxxxxx.com/admincp/pod_tips.php?do=dodelete
Referrer : http://xx.xxxxx.com/admincp/pod_tips...o=delete&id=52
IP Address : xxxxxxx
Username : xxxx
Classname : vB_Database
MySQL Version : 4.1.22-standard

Please, try to replace your admincp/pod_tips.php with the one attached in this post. If it works, I'll replace the package in the first post :D

GOOD JOB.

No more database errors.

Just can't see it on my forum now, LOL...

EDIT: turning off my other forumhome plugins, such as photopost integration, does not do anything. Does not seem to be interference with the other plugins. I guess I need to upgrade to vb 4.04...

Your navbar template seems ok. I think it should work even in 4.0.3.

Please try this, admincp > Settings > Options > Tips of the day Settings. Make sure the first two options are yes (both active and persistent tips).

You can turn off persistent tips later if you wish, but for testing it's better to have it on.

Had them both on. Didn't work.

Upgrading to 4.04. I guess it's time, LOL

If you don't have any other reason for upgrading, hold on, I think I can fix the compatibility with 4.0.3.

Upgraded.
Tips works!

Awesome script. Keep up the good work. Need to make more tips....

Good to know it works :D

Anyway, I did the appropriate changes, if anyone wants to run it on vb4.0.3, it should work now.