Bug Wrong Seo links for the DB Review
- Thread starter markoroots
- Start date
- Status
markoroots
Customer
Thanks Fillip.
I'm sending you a PM.
Then also I don't understand what issue you cannot replicate in SEF.
I'm sending you a PM.
Then also I don't understand what issue you cannot replicate in SEF.
Last edited:
markoroots
Customer
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.
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.
markoroots
Customer
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.
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:
markoroots
Customer
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 :
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 :
markoroots
Customer
Thanks Fillip, plugin updated.
So, have you checked the problems of the wrong collocations of the reviews in both forums?
So, have you checked the problems of the wrong collocations of the reviews in both forums?
markoroots
Customer
Hi Fillip,
the ftp details for Vaporizer Forum are right.
I have just tried now and it is work.
the ftp details for Vaporizer Forum are right.
I have just tried now and it is work.
markoroots
Customer
Fillip H. shall I have to wait some other month to fix these errors? 
markoroots
Customer
Fillip H. still no news from you. 
I'm still waiting for the correct FTP details
https://www.dropbox.com/s/iorspsdjfbqw77q/Screenshot 2015-07-24 15.46.30.png?dl=0
https://www.dropbox.com/s/iorspsdjfbqw77q/Screenshot 2015-07-24 15.46.30.png?dl=0
markoroots
Customer
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.
All the last details I sent you are correct and working.
markoroots
Customer
Ahh yes...
Quite sure this is the problem.
I have to open the automatic filter.
I do it now.
Quite sure this is the problem.
I have to open the automatic filter.
I do it now.
markoroots
Customer
Fillip H.
Filters removed.
Filters removed.
- Status
Similar threads
- Locked
- Support ticket
Question
Imported reviews from thread
