Bug Wrong Seo links for the DB Review

Status
Not open for further replies.
Update: I'm looking into this @ your site now, thank you for your patience :)
 
Last edited:
Update 2: I am unable to replicate this issue @ the SigarettaElectronica site, and I do not have AdminCP access to the Vaporizer site at this time. Please advise.
 
Thanks Fillip.
I'm sending you a PM.

Then also I don't understand what issue you cannot replicate in SEF.
 
Last edited:
Hi Fillip H.,
please, are there any news?

Then there is also a new problem with this plugin.
Every time that I modify a title of a review, after few minutes come back alone with the old uncorrected title there was before.
 
Sorry, I've not had a chance to look into this yet. I'll hopefully get to it tonight or tomorrow :)
 
Hi Fillip H. any news?
Sure that is really difficult to have some support here in DBT.
I still must edit each review in the database to show them in the plugin.
 
Last edited:
I've tried to resolve this @ your site, but the FTP info I have appears to be for the SigarettaElectronica forum, not the Vaporizer one. Could you please also PM me with a FTP account for that site?
 
Fillip H. in minutes I will send you all the details.
On Sigaretta Elettronica Forum the problem is still there and are arriving to me many errors by email, see here:


Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT
entry.*,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
receiveduser.username AS receivedusername,
receiveduser.usergroupid AS receivedusergroupid,
receiveduser.membergroupids AS receivedmembergroupids,
receiveduser.infractiongroupid AS receivedinfractiongroupid,
receiveduser.displaygroupid AS receiveddisplaygroupid

FROM (
(
SELECT
post.postid,
post.title AS posttitle,
post.pagetext AS pagetext,
thread.title AS threadtitle,
thread.title AS title,
thread.threadid,
thread.forumid,
entry_post.*
FROM vb4_dbtech_thanks_entry AS entry_post
LEFT JOIN vb4_post AS post ON (post.postid = entry_post.contentid)
LEFT JOIN vb4_thread AS thread ON (thread.threadid = post.threadid)
WHERE entry_post.entryid IN(3485, 3482, 3455, 3453, 3451, 3450, 3449, 3448, 3447, 3446, 3445, 3443, 3440, 3439, 3433, 3432, 3431, 3430)
AND post.visible = 1
) UNION ALL (
SELECT
review.reviewid AS postid,
review.title_clean AS posttitle,
review.short_text AS pagetext,
review.title_clean AS threadtitle,
review.title_clean AS title,
review_instance.shortname AS threadid,
0 AS forumid,
entry_dbreview_review.*
FROM vb4_dbtech_thanks_entry AS entry_dbreview_review
LEFT JOIN vb4_dbtech_review_reviews AS review ON (review.reviewid = entry_dbreview_review.contentid)
LEFT JOIN vb4_dbtech_review_instances AS review_instance ON (review_instance.instanceid = review.instanceid)
WHERE entry_dbreview_review.entryid IN(3427, 3426)
)
) AS entry
LEFT JOIN vb4_user AS user ON(user.userid = entry.userid)
LEFT JOIN vb4_user AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;

MySQL Error : Unknown column 'review.short_text' in 'field list'
Error Number : 1054
Request Date : Monday, July 13th 2015 @ 04:36:09 PM
Error Date : Monday, July 13th 2015 @ 04:36:09 PM
Script : Sigaretta Elettronica Forum Database Error
Referrer : Sigaretta Elettronica Forum
IP Address : 93.58.31.180
Username : Marko
Classname : vB_Database_MySQLi
MySQL Version : 5.5.42-cll-lve



Database error in vBulletin 4.2.3:

Invalid SQL:

SELECT
entry.*,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid,
receiveduser.username AS receivedusername,
receiveduser.usergroupid AS receivedusergroupid,
receiveduser.membergroupids AS receivedmembergroupids,
receiveduser.infractiongroupid AS receivedinfractiongroupid,
receiveduser.displaygroupid AS receiveddisplaygroupid

FROM (
(
SELECT
post.postid,
post.title AS posttitle,
post.pagetext AS pagetext,
thread.title AS threadtitle,
thread.title AS title,
thread.threadid,
thread.forumid,
entry_post.*
FROM vb4_dbtech_thanks_entry AS entry_post
LEFT JOIN vb4_post AS post ON (post.postid = entry_post.contentid)
LEFT JOIN vb4_thread AS thread ON (thread.threadid = post.threadid)
WHERE entry_post.entryid IN(3485, 3482, 3455, 3453, 3451, 3450, 3449, 3448, 3447, 3446, 3445, 3443, 3440, 3439, 3433, 3432, 3431, 3430)
AND post.visible = 1
) UNION ALL (
SELECT
review.reviewid AS postid,
review.title_clean AS posttitle,
review.short_text AS pagetext,
review.title_clean AS threadtitle,
review.title_clean AS title,
review_instance.shortname AS threadid,
0 AS forumid,
entry_dbreview_review.*
FROM vb4_dbtech_thanks_entry AS entry_dbreview_review
LEFT JOIN vb4_dbtech_review_reviews AS review ON (review.reviewid = entry_dbreview_review.contentid)
LEFT JOIN vb4_dbtech_review_instances AS review_instance ON (review_instance.instanceid = review.instanceid)
WHERE entry_dbreview_review.entryid IN(3427, 3426)
)
) AS entry
LEFT JOIN vb4_user AS user ON(user.userid = entry.userid)
LEFT JOIN vb4_user AS receiveduser ON(receiveduser.userid = entry.receiveduserid)
ORDER BY entryid DESC
LIMIT 20;

MySQL Error : Unknown column 'review.short_text' in 'field list'
Error Number : 1054
Request Date : Sunday, July 12th 2015 @ 04:04:10 PM
Error Date : Sunday, July 12th 2015 @ 04:04:11 PM
Script : Sigaretta Elettronica Forum Database Error
Referrer :
IP Address : 157.55.39.166
Username : Non Registrato
Classname : vB_Database_MySQLi
MySQL Version :
 
This has been fixed in newer versions of the APTL mod. Please make sure you have updated it :)
 
Thanks Fillip, plugin updated.
So, have you checked the problems of the wrong collocations of the reviews in both forums?
 
I'm unable to connect to the FTP server on the VaporizerForum site. Can you please provide the correct FTP host, FTP user and FTP password? Thanks :)
 
Fillip H. I have just sent you and checked if were working because you told me that they didn't.
All the last details I sent you are correct and working.
 
I'm still receiving the same error as per my previous screenshot. Please make sure your FTP server is not filtering IP addresses.
 
I managed to get access now, I'll keep this tab open and look into it as soon as I can :)

I'll post back if I need more information.
 
Status
Not open for further replies.

Legacy DragonByte Reviews

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
190
Customer rating
0.00 star(s) 0 ratings
Back
Top