Bug DBSEO 2.0.17 and VB3.6.4

[gha120]

Hi Support,

We are having as issue with with class_db.php script it is failing on this query a lot the table exists and has keywords in but I can't pin point why its failing. Please can you assist.

Below is an error log of the following:

error_log(serialize($link->get_connection_stats()));
error_log(serialize($link->get_warnings()));
error_log($link->sqlstate);
error_log($queryresult);
error_log($buffered);
error_log(MYSQLI_STORE_RESULT);
error_log($this->sql);
error_log(serialize($this->connection_recent));

[27-Aug-2015 08:24:27 UTC] N;
[27-Aug-2015 08:24:27 UTC] N;
[27-Aug-2015 08:24:27 UTC]
[27-Aug-2015 08:24:27 UTC]
[27-Aug-2015 08:24:27 UTC] 1
[27-Aug-2015 08:24:27 UTC] 0
[27-Aug-2015 08:24:27 UTC]
SELECT *
FROM dbtech_dbseo_keyword
ORDER BY priority DESC, keyword ASC

[27-Aug-2015 08:24:27 UTC] O:6:"mysqli":19:{s:13:"affected_rows";N;s:11:"clie nt_info";N;s:14:"client_version";N;s:13:"connect_e rrno";N;s:13:"connect_error";N;s:5:"errno";N;s:5:" error";N;s:10:"error_list";N;s:11:"field_count";N; s:9:"host_info";N;s:4:"info";N;s:9:"insert_id";N;s :11:"server_info";N;s:14:"server_version";N;s:4:"s tat";N;s:8:"sqlstate";N;s:16:"protocol_version";N; s:9:"thread_id";N;s:13:"warning_count";N;}

 

[Fillip H.]

Those aren't error messages that indicate any point of failure, can you please give me the error message that was sent to your technicalemail email address?

 

[gha120]

Database error in DragonByte SEO 2.0.17:

Invalid SQL:

SELECT *
FROM dbtech_dbseo_keyword
ORDER BY priority DESC, keyword ASC;

MySQL Error :
Error Number :
Date : Wednesday, August 26th 2015 @ 11:48:03 PM
Script : http://www.cardschat.com/cron.php?&rand=982053
Referrer : http://www.cardschat.com/usercp.php
IP Address : 204.2.223.84
Username : N/A
Classname : DBSEO_Database_MySQLi

 

[Fillip H.]

What happens if you manually run this query in phpMyAdmin or the vBulletin AdminCP?

 

[gha120]

comes back fine with an empty results set. tried it with adding keyword in as well and they came back fine as part of the query

 

[Fillip H.]

Then it's most likely a temporary issue with your server, as there is no error with that query

 

[Fillip H.]

Hello gha120,

This ticket has now been closed with the status Not A Bug.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!

 

[gha120]

Fillip H.

This issue is still present I don't find a response of its probably a temp issue as satisfactory and would appreciate further investigation from your side of house.

Also to note its the class_db halt that is causing this

 

[Fillip H.]

Could you please create and PM me with a temporary FTP and AdminCP account?

For security reasons, we recommend you create a new FTP account only for DBTech support, then disable or delete it after we have both confirmed the issue has been solved and there are no further issues.

The same applies to AdminCP accounts; they should ideally be temporary accounts created for us only. If we have created an account on your site already, you can optionally boost that account to Administrator and then de-admin this account once the issue has been solved.

If you use a .htaccess password protection for your AdminCP directory, it is recommended that you create a new authorised user for DBTech and remove this user once the issue has been solved.

Please test any temporary accounts you create to ensure that the FTP account has access to the forum files, and that the AdminCP account can access the administrative controls for the product we are assisting you with.

Ensuring this is all in order before submitting the information will significantly speed up the process of assisting you. We will alert you via PM if there's any issues with the login information you have provided.

When sending the PM, for your security you should also un-tick the "Save a copy in my Sent Items folder" checkbox. When the access details have been received, we will delete the PM from our inbox. Ensuring you have not kept a copy of the PM reduces the risk of security breaches.

Thank you for helping us debug our products and allowing us to assist you, we appreciate it

 

[gha120]

Fillip H.

as requested you have been pm'd

 

[Fillip H.]

The reason why this is happening is that somewhere, your server is stripping POST requests and removing "index.php" from the URL query.

I am not able to find a reason for this, but I do know the problem is not in DBSEO as it does not function even when the DBSEO .htaccess file edit is not applied.

 

[gha120]

Fillip H.

since it looks like you tried to change htaccess settings and broke the rest of the site. the DBSEO rules are in the apache config directly.

Please tell me the other changes you have tried to make so I can ensure the rest of the site is working as it should.

Also can we have an update on the progress of this request.

Regards,
John

 

[Fillip H.]

I see, well in that case there's nothing further I can do unfortunately. This issue is server-side, probably a malformed .htaccess rule that's causing this.

What request are you referring to?

 

[gha120]

@belavor

The current request, this support thread. You say its a malformed rule they are no different from the ones you added to the htaccess. how you got anyone we can pay to diagnose and fix with us?

 

[Fillip H.]

Unfortunately I don't know of anyone that would be able to figure this out, sorry

 

[Fillip H.]

Hello gha120,

This ticket has now been closed with the status Not A Bug.

We hope your issue or question has been addressed to your satisfaction. If not, please feel free to re-open it by clicking this link.

If you have any further issues or questions, please feel free to start a new support ticket via the button at the top of every page.

Thank you!