vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Add-On Releases - vBulletin Raffles (https://vborg.vbsupport.ru/showthread.php?t=262901)

BadgerDog 06-03-2011 02:45 PM

Just tried to install this on 4.1.3 ....

Received an SQL error during install ...

Seemed to go through first part of import and install process fine....

Quote:

Importing Product, Please Wait...

[:]
Start Installing Active Raffle List Forum Block

Active Raffle List Forum Block Install Finished
... then it updated style information ...

Quote:

Updating style information for each style

Light ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Dark ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.

Medium ... (Templates) (StyleVars) (Replacement Variables) (CSS) (Controls) Done.
... then it CRASHED ..... :(

I put xxx's in some places for privacy ....

Quote:

Sapporo, Yakutsk\";s:22:\"timezone_gmt_plus_0930\";s:28:\"( GMT +9:30) Adelaide, Darwin\";s:22:\"timezone_gmt_plus_1000\";s:49:\"(G MT +10:00) Eastern Australia, Guam, Vladivostok\";s:22:\"timezone_gmt_plus_1100\";s:52 :\"(GMT +11:00) Magadan, Solomon Islands, New Caledonia\";s:22:\"timezone_gmt_plus_1200\";s:50:\ "(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka\";}' WHERE languageid = 1;

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE language SET title = title, phrasegroup_cprofilefield = 'a:31:{s:25:\"eznl_we_send_forum_digest\"; Note: long set of field statements... carries on through several fields ... didn't bother to put them here ...

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Friday, June 3rd 2011 @ 11:39:33 AM
Error Date : Friday, June 3rd 2011 @ 11:39:58 AM
Script : http://www.xxxx.com/admincp/plugin.php?do=productimport
Referrer : http://www.xxxx.com/admincp/plugin.php?do=productadd
IP Address : xx.xx.xx.xxxx
Username : Badger
Classname : vB_Database
MySQL Version : 5.0.77
Any ideas what to do next, or how I can un-install this half baked install?

Thanks ... :)

Regards,
Doug

ps: It appears some pieces installed in spite of the SQL crash. (see pic). Is the blank field under Administrator Permissions yours and should it say "Can Admin Raffles"? Hope this stuff reported helps you troubleshoot the problem as we'd like to use this mod.

ChromeDome 06-03-2011 04:03 PM

Thanks.

Another question. Any tips on how to align my raffle image in the center?
http://www.chromebookuser.com/raffle...do=raffle&id=1

In IE and FF it shows up on the right. In Chrome and Safari it shows up on the left. Whenever I edit the default raffle css, the image then appears under the section that displays the raffle status.

nhawk 06-03-2011 04:42 PM

Quote:

Originally Posted by BadgerDog (Post 2203087)
Sapporo, Yakutsk\";s:22:\"timezone_gmt_plus_0930\";s:28:\"( GMT +9:30) Adelaide, Darwin\";s:22:\"timezone_gmt_plus_1000\";s:49:\"(G MT +10:00) Eastern Australia, Guam, Vladivostok\";s:22:\"timezone_gmt_plus_1100\";s:52 :\"(GMT +11:00) Magadan, Solomon Islands, New Caledonia\";s:22:\"timezone_gmt_plus_1200\";s:50:\ "(GMT +12:00) Auckland, Wellington, Fiji, Kamchatka\";}' WHERE languageid = 1;

Database error in vBulletin 4.1.3:

The statements about timezone are not part of my mod. I don't know where that's coming from. It may be part of one of your templates and that's throwing the error.

Quote:

Originally Posted by BadgerDog (Post 2203087)

"MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes"

This error is a problem with your MySQL configuration. It's probably always been there, but it reared it's ugly head now.

See this for more info..

http://dev.mysql.com/doc/refman/5.0/...too-large.html


Quote:

Originally Posted by BadgerDog (Post 2203087)
Any ideas what to do next, or how I can un-install this half baked install?

I'd go into the database with phpMyAdmin and delete the two raffle tables if they exist. But, I'd also be very careful about doing that. If you fix whatever the problem is with your template, you could just try installing again and it will just complete the install.

Quote:

Originally Posted by BadgerDog (Post 2203087)
ps: It appears some pieces installed in spite of the SQL crash. (see pic). Is the blank field under Administrator Permissions yours and should it say "Can Admin Raffles"? Hope this stuff reported helps you troubleshoot the problem as we'd like to use this mod.

It could be, but I can't be sure without the label.

ChromeDome 06-03-2011 04:47 PM

NVM, I figured out a fix.

nhawk 06-03-2011 04:54 PM

Quote:

Originally Posted by ChromeDome (Post 2203119)
Thanks.

Another question. Any tips on how to align my raffle image in the center?
http://www.chromebookuser.com/raffle...do=raffle&id=1

In IE and FF it shows up on the right. In Chrome and Safari it shows up on the left. Whenever I edit the default raffle css, the image then appears under the section that displays the raffle status.

I don't normally support customization of the templates. But try

display:block
clear:both

ChromeDome 06-03-2011 06:34 PM

Sorry... I figured out all of my problems, thanks. I was using HTML in the raffle description and it was causing some problems... * sighs *

nhawk 06-03-2011 07:41 PM

Quote:

Originally Posted by ChromeDome (Post 2203172)
Sorry... I figured out all of my problems, thanks. I was using HTML in the raffle description and it was causing some problems... * sighs *

Gotcha :)

FYI, BB Codes will work in raffle descriptions. ;)

Harley D 06-04-2011 07:56 AM

Quote:

Originally Posted by ChromeDome (Post 2203130)
NVM, I figured out a fix.

Care to share that fix?

BadgerDog 06-04-2011 02:11 PM

Quote:

Originally Posted by nhawk (Post 2203129)
This error is a problem with your MySQL configuration. It's probably always been there, but it reared it's ugly head now.

See this for more info..

http://dev.mysql.com/doc/refman/5.0/...too-large.html

Thanks ... :)

Increased the variable to 16Mb and the re-install went fine. :up:

Mod seems to be working fine but I haven't done any real testing. I'll report any anomalies to you ... appreciate the support .... :)

Regards,
Doug

BadgerDog 06-04-2011 02:28 PM

Are there any instructions anywhere to show how to define and setup the profile fields (type etc) for the address, phone number and PayPal data?

Thanks .. :)

Regards,
Doug


All times are GMT. The time now is 06:54 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

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