Hi I've installed the mod on a test server running vb 4.2.2 P3 and I keep getting this error when I try a recount or if a cron job runs:
Quote:
Invalid SQL:
SELECT
COUNT(*) as mypictures
FROM vbf_ppgal_images
WHERE valid=1 AND userid=1
AND ppgal_images.dateline > 315532800;
MySQL Error : Unknown column 'ppgal_images.dateline' in 'where clause'
Error Number : 1054
Request Date : Tuesday, December 16th 2014 @ 01:17:42 PM
Error Date : Tuesday, December 16th 2014 @ 01:17:43 PM
Script : xperience_admin.php?do=xperience_admin_recount_xp
Referrer : xperience_admin.php?do=recount
IP Address : 173.245.54.100
Username : Admin
Classname : vB_Database
MySQL Version : 5.1.73
|
I've tried a few times to re-upload and re-install but I cannot seem to get rid of this error. It also generates the error in the "vBExperience vBGallery" plugin is disabled. If uninstalled, the recount works with no issue. I've also tried with just the gallery plugin alone.
Has anyone seen this problem? Can you please let me know how to fix it?