vb.org Archive - Add-On Releases - Prosperent Product Search and Auto-Linker

Page 12 of 14

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Add-On Releases - Prosperent Product Search and Auto-Linker (https://vborg.vbsupport.ru/showthread.php?t=277492)

99SIVTEC

02-27-2012 03:23 PM

Quote:

Originally Posted by shona (Post 2303827)

hi,

just tried to install this in vbulletin 4.1.9 forum

and forum index now is a blank page with the following error message:

have removed all files & uninstalled the xml file so the forum will function again. any suggestions?

also the install instructions say there are 4 files and 2 images in the folder which need to be ftp'ed in but I am seeing 6 php files + 5 images in /img/

thanks :)

Hey, what is your forums url?

And that's a mistake, I guess I had forgotten to update that in the write up when I updated it. Sorry about that.

J-P	02-27-2012 03:53 PM

the product.php page seems to be giving an unusual amount of database errors. I get at least 10 a day with it disabled and and more when it is enabled.

Code:

Database error in vBulletin 4.1.10:



Invalid SQL:

SELECT *

    FROM rbs_banners 

    WHERE enabled=1

        AND startdate<=1330360708

        AND enddate>=1330360708

        AND IF(forumhome, 0=0, IF(forumids='', 1, FIND_IN_SET('0', forumids)))

        AND IF(maximpressions>0, impressions<maximpressions, 1)

        AND IF(clicktrack, maxclicks=0 OR (maxclicks>0 AND clicks<maxclicks), 1);



MySQL Error  : MySQL server has gone away

Error Number  : 2006

Request Date  : Monday, February 27th 2012 @ 10:38:28 AM

Error Date    : Monday, February 27th 2012 @ 10:38:39 AM

Script        : http://www.invertplanet.com/forum/product.php?q=Sage-O-Soothe%20Tea%203.2%20oz%20by%20North%20American%20Herb%20&Spice=

Referrer      : 

IP Address    : 207.46.204.188

Username      : Unregistered

Classname    : vB_Database

MySQL Version :

There are various error messages but they all stem from the product.php page :(

99SIVTEC

02-27-2012 04:17 PM

Quote:

Originally Posted by J-P (Post 2303899)

the product.php page seems to be giving an unusual amount of database errors. I get at least 10 a day with it disabled and and more when it is enabled.

There are various error messages but they all stem from the product.php page :(

Have you upgraded to the newest version yet? If not, I can do that for you real quick if that information you gave me last time works still. The newest version should fix the errors.

J-P	02-27-2012 05:14 PM

just upgraded.

Will let you know :)

Thank you :D

99SIVTEC

02-27-2012 05:17 PM

Quote:

Originally Posted by J-P (Post 2303938)

just upgraded.

Will let you know :)

Thank you :D

No problem. Yea that should fix any mySQL errors that you were getting, its a much more stable and faster version. :)

99SIVTEC

03-01-2012 03:43 PM

So how's 1.6 working for everyone?

J-P	03-01-2012 04:34 PM

still getting DB errors from unregistered users but not nearly as many as before. When I asked the hosting about this I received this reply:

Quote:

Apache timeout: 30 seconds
MySQL timeout: 10 seconds
PHP Execution timeout: 45 seconds

I don't know if it is the time outs that are causing this or the cache.

99SIVTEC

03-01-2012 06:43 PM

Quote:

Originally Posted by J-P (Post 2305073)

still getting DB errors from unregistered users but not nearly as many as before. When I asked the hosting about this I received this reply:

I don't know if it is the time outs that are causing this or the cache.

Which error is it giving you. Its been running fine on a test site, whether I'm logged in or not.

J-P	03-02-2012 01:19 PM

This is the most common.

Quote:

Database error in vBulletin 4.1.10:

Invalid SQL:

SELECT *
FROM style
WHERE (styleid = 5 AND userselect = 1)
OR styleid = 5
ORDER BY styleid ASC
LIMIT 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, March 2nd 2012 @ 03:44:19 AM
Error Date : Friday, March 2nd 2012 @ 03:44:31 AM
Script : http://www.invertplanet.com/forum/pr...d+Sheepskin+Co
Referrer :
IP Address : 66.249.72.243
Username : Unregistered
Classname : vB_Database
MySQL Version :

This one come up on occasion:

Quote:

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT *
FROM rbs_banners
WHERE enabled=1
AND startdate<=1330678621
AND enddate>=1330678621
AND IF(forumhome, 0=0, IF(forumids='', 1, FIND_IN_SET('0', forumids)))
AND IF(maximpressions>0, impressions<maximpressions, 1)
AND IF(clicktrack, maxclicks=0 OR (maxclicks>0 AND clicks<maxclicks), 1);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Friday, March 2nd 2012 @ 02:57:01 AM
Error Date : Friday, March 2nd 2012 @ 02:57:14 AM
Script : http://www.invertplanet.com/forum/pr...ng's%20Ent.
Referrer :
IP Address : 66.249.72.243
Username : Unregistered
Classname : vB_Database
MySQL Version :

I just noticed that the request date and error dates are just a tad over the 10 second limit :(

shona

03-06-2012 12:56 AM

Quote:

Originally Posted by 99SIVTEC (Post 2303890)

Hey, what is your forums url?

And that's a mistake, I guess I had forgotten to update that in the write up when I updated it. Sorry about that.

forum url is http://inverts.com.au

thanks :)

All times are GMT. The time now is 03:38 PM.

Page 12 of 14

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01153 seconds Memory Usage 1,750KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: