100's of errors are produced when this product is activated.. I have to uninstall it to stop the issues.
I have done this twice. Once with initial release and once since your updates were completed.
process
All files uploaded and product installed.
Everything okay
Management tools - > create tabs -> I created 4 tabs
Everything okay - I can browse any pages and no errors are being reported.
Management tools -> Add Views to category.
As soon as I add one view to a category and save it, the errors start and they are from all over the place..
Here are a few examples. I get tons of these all at once until I uninstall the product.
----------------------------
Invalid SQL:
SELECT statistics.*
FROM redtailpm AS pm
LEFT JOIN redtailpmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN redtaildbtech_thanks_statistics AS statistics ON(statistics.userid = pmtext.fromuserid)
WHERE pm.userid = 7686 AND pm.pmid = 105649;
MySQL Error : Table 'redtail_vbulletin.redtaildbtech_thanks_statistics' doesn't exist
Error Number : 1146
Request Date : Sunday, January 30th 2011 @ 12:11:32 PM
Error Date : Sunday, January 30th 2011 @ 12:11:32 PM
Script : http://www.redtailboas.com/private.php?do=showpm&pmid=105649
Referrer : http://www.redtailboas.com/usercp.php
----------------------------------------
Invalid SQL:
SELECT announcement.announcementid, announcement.announcementid AS postid, startdate, enddate, announcement.title, pagetext, announcementoptions, views,
user.*, userfield.*, usertextfield.*,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
, pbtabs_blog.blogid AS pbtabs_blogid, pbtabs_blog.dateline AS pbtabs_blogdateline, pbtabs_blog_text.title AS pbtabs_blogtitle, pbtabs_thread.threadid AS pbtabs_threadid, pbtabs_thread.dateline AS pbtabs_threaddateline, pbtabs_thread.title AS pbtabs_threadtitle
FROM redtailannouncement AS announcement
LEFT JOIN redtailuser AS user ON(user.userid=announcement.userid)
LEFT JOIN redtailuserfield AS userfield ON(userfield.userid=announcement.userid)
LEFT JOIN redtailusertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN redtailsigpic AS sigpic ON(sigpic.userid = announcement.userid)
LEFT JOIN redtailavatar AS avatar ON(avatar.avatarid=user.avatarid)
LEFT JOIN redtailcustomavatar AS customavatar ON(customavatar.userid=announcement.userid)
LEFT JOIN redtailblog AS pbtabs_blog ON(pbtabs_blog.userid = announcement.userid AND pbtabs_blog.blogid = (
SELECT MAX(blogid)
FROM redtailblog AS blog
WHERE blog.userid = announcement.userid)
)
LEFT JOIN redtailblog_text AS pbtabs_blog_text ON(pbtabs_blog_text.blogtextid = pbtabs_blog.firstblogtextid) LEFT JOIN redtailthread AS pbtabs_thread ON(pbtabs_thread.postuserid = announcement.userid AND pbtabs_thread.threadid = (
SELECT MAX(threadid)
FROM redtailthread AS thread
WHERE thread.postuserid = announcement.userid)
)
WHERE
startdate <= 1296407624 AND enddate >= 1296407624 AND announcement.forumid IN (115,4,-1)
ORDER BY startdate DESC, announcementid DESC;
MySQL Error : Column 'pagetext' in field list is ambiguous
Error Number : 1052
I have done this twice. Once with initial release and once since your updates were completed.
process
All files uploaded and product installed.
Everything okay
Management tools - > create tabs -> I created 4 tabs
Everything okay - I can browse any pages and no errors are being reported.
Management tools -> Add Views to category.
As soon as I add one view to a category and save it, the errors start and they are from all over the place..
Here are a few examples. I get tons of these all at once until I uninstall the product.
----------------------------
Invalid SQL:
SELECT statistics.*
FROM redtailpm AS pm
LEFT JOIN redtailpmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN redtaildbtech_thanks_statistics AS statistics ON(statistics.userid = pmtext.fromuserid)
WHERE pm.userid = 7686 AND pm.pmid = 105649;
MySQL Error : Table 'redtail_vbulletin.redtaildbtech_thanks_statistics' doesn't exist
Error Number : 1146
Request Date : Sunday, January 30th 2011 @ 12:11:32 PM
Error Date : Sunday, January 30th 2011 @ 12:11:32 PM
Script : http://www.redtailboas.com/private.php?do=showpm&pmid=105649
Referrer : http://www.redtailboas.com/usercp.php
----------------------------------------
Invalid SQL:
SELECT announcement.announcementid, announcement.announcementid AS postid, startdate, enddate, announcement.title, pagetext, announcementoptions, views,
user.*, userfield.*, usertextfield.*,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
, pbtabs_blog.blogid AS pbtabs_blogid, pbtabs_blog.dateline AS pbtabs_blogdateline, pbtabs_blog_text.title AS pbtabs_blogtitle, pbtabs_thread.threadid AS pbtabs_threadid, pbtabs_thread.dateline AS pbtabs_threaddateline, pbtabs_thread.title AS pbtabs_threadtitle
FROM redtailannouncement AS announcement
LEFT JOIN redtailuser AS user ON(user.userid=announcement.userid)
LEFT JOIN redtailuserfield AS userfield ON(userfield.userid=announcement.userid)
LEFT JOIN redtailusertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN redtailsigpic AS sigpic ON(sigpic.userid = announcement.userid)
LEFT JOIN redtailavatar AS avatar ON(avatar.avatarid=user.avatarid)
LEFT JOIN redtailcustomavatar AS customavatar ON(customavatar.userid=announcement.userid)
LEFT JOIN redtailblog AS pbtabs_blog ON(pbtabs_blog.userid = announcement.userid AND pbtabs_blog.blogid = (
SELECT MAX(blogid)
FROM redtailblog AS blog
WHERE blog.userid = announcement.userid)
)
LEFT JOIN redtailblog_text AS pbtabs_blog_text ON(pbtabs_blog_text.blogtextid = pbtabs_blog.firstblogtextid) LEFT JOIN redtailthread AS pbtabs_thread ON(pbtabs_thread.postuserid = announcement.userid AND pbtabs_thread.threadid = (
SELECT MAX(threadid)
FROM redtailthread AS thread
WHERE thread.postuserid = announcement.userid)
)
WHERE
startdate <= 1296407624 AND enddate >= 1296407624 AND announcement.forumid IN (115,4,-1)
ORDER BY startdate DESC, announcementid DESC;
MySQL Error : Column 'pagetext' in field list is ambiguous
Error Number : 1052
