vb.org Archive - Major Additions - ibProArcade

After having this arcade for a few weeks and really enjoying it, I was forced to uninstall it today. My site started going down... the database was being corrupted. I had to do multiple repairs. ALL database errors were concerning the arcade.

The following error was just one of many:
mySQL query error: SELECT * FROM vb_games_settings mySQL error: mySQL error code: Date: Tuesday 07th of February 2006 03:38:55 PM

I hope I can reinstall it in the near future, but not for now

Quote:

Originally Posted by flypaper

I have not installed this arcade, but can pretty much guess that it wasn't the arcade. In a 99 page thread, that problem probably would have surfaced on page 30.

Good luck tho.

oh no? I got several database errors and they were all related to the arcade... the one I posted was just one of many.

AND... since I uninstalled it, there's been no more errors and I've not been down once. It was the arcade in one way or another

trilljester

02-08-2006 01:53 PM

Thanks again for this Mr. Zeropage, it really is one of my favorite mods, been using this arcade system since it was a beta for IPB 1.3, and to be able to use it again with VBulletin has been awesome.

Question: Are there any plans to integrate the arcade with any of these "shop" and "cash" mods that are popping up everywhere?

trilljester

02-08-2006 01:59 PM

Quote:

Originally Posted by Ohiosweetheart

Where's the mySQL error code? How many users do you normally get hitting your site/arcade? I had a zerg rush of users once in my arcade of close to 75 users, and it never had any database problems. Who's doing your database hosting? It's possible that the mySQL server can't handle large amounts of traffic. It's one of the many reasons no large companies use mySQL for their database solution.

Thieutje

02-08-2006 02:04 PM

Quote:

Originally Posted by trilljester

Who's doing your database hosting? It's possible that the mySQL server can't handle large amounts of traffic. It's one of the many reasons no large companies use mySQL for their database solution.

Can you please give a good webhosting website who can handle heavy traffic and is superior in SQL database implementation.

Grtz
Thieutje

Ohiosweetheart

02-08-2006 03:45 PM

Quote:

Originally Posted by trilljester

NO larger companies use MySQL for their database solution? I'm not sure where you get your information, but nearly every single large host that I know of uses mySQL.

I don't have a large site, and there were only 3 people in the arcade when the database went down.

Anyway, the situation has been corrected and I may try this arcade again.

fly	02-08-2006 03:57 PM

Quote:

Originally Posted by Ohiosweetheart

What was the problem?

trilljester

02-08-2006 05:14 PM

Quote:

Originally Posted by Ohiosweetheart

Not going to get into a database war here, I just know there's a reason why so many large companies choose Oracle or other commercial offerings over mySQL. If your hosting offered mySQL or Oracle, which would you take?

Anyways, good to see you got your problem solved. What was the issue?

Ohiosweetheart

02-08-2006 06:54 PM

Quote:

Originally Posted by trilljester

LOL... there is no database war. I have no idea what Oracle is, as every single host I've checked into offers mySQL, so I wouldn't know anything about Oracle.

Actually my problem isn't solved.... I just tried to install this arcade again and my site crashed again. SO this is out for me.

trilljester

02-08-2006 06:56 PM

Yeah, it's not a bad idea for hosting companies to offer mySQL to their customers. It's free and works for most of their customer's applications. Hell, I use it on my site for that very reason. I'd only go to a commercial solution if the traffic on my site got to the point where mySQL can't handle it anymore. Not that it would ever happen, but if it does, there's that option.

Can you post the full error message so we can help troubleshoot? I'm not sure what's going on, it might be a simple setup issue.

Ohiosweetheart

02-08-2006 06:57 PM

Quote:

Originally Posted by flypaper

What was the problem?

no idea... as I just tried to install the arcade again and my site crashed again. Obviously there's something about the arcade that's conflicting with my databases

All times are GMT. The time now is 02:10 PM.

Page 148 of 758

148

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09205 seconds Memory Usage 1,756KB 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 (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (7)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: