vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Webpage & Guestbook Script (https://vborg.vbsupport.ru/showthread.php?t=71065)

Lionel 10-28-2004 10:13 AM

Quote:

Originally Posted by Swedie
I double checked my .SQL file and ran it on a new database (copied my forum) and it installed flawlessly. Only trouble I saw was that it was saved using Unix style or somethign so if the SQL file is run as it is, some line brakes may not appear correctly, hence causing a problem.

This problem has been addressed in the new .ZIP file in my first post here in this thread.

I've also updated the installation instructions for your convenience.

Got more than that. Perhaps the Sweedish version is different? For example nothing was showing up in Control Panel as pictured above by someone. That was due to the fact that all names were inserted in the wrong fields. I had to manually adjust every single one of them.

Swedie 10-28-2004 10:21 AM

Quote:

Originally Posted by Lionel
Got more than that. Perhaps the Sweedish version is different? For example nothing was showing up in Control Panel as pictured above by someone. That was due to the fact that all names were inserted in the wrong fields. I had to manually adjust every single one of them.

hmm! odd... are you talking about the languageid field .. please specify and I'll make the correction to the .SQL file. thanks

Lionel 10-28-2004 10:24 AM

I am talking about the setting groups.

Lionel 10-28-2004 10:27 AM

here, all the ones in that series were wrong:
INSERT INTO `setting` VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);

the value 'guestbookwebpage' for example should have been the second one. The yesno is wrong etc...

Swedie 10-28-2004 10:45 AM

Quote:

Originally Posted by Lionel
here, all the ones in that series were wrong:
INSERT INTO `setting` VALUES ('allowguestbook', '1', 'yesno', 10, 'guestbookwebpage', '1', 0, 1);

the value 'guestbookwebpage' for example should have been the second one. The yesno is wrong etc...

Thing is that I've done a simple SQL dump and copied the INSERT's that PHPMYADMIN created for me for re-creating the database. I can't see how it would create the fields wrongly.

The fields goes like this:
varname, value, optioncode, displayorder, grouptitle, defaultvalue, advanced, volatile
the order in the INSERT CODE is correct... if you look at above line

Also when I am executing the SQL file and I'm looking at the database for any wrong inputs I can't see any wrongs. Everything is where it should be.

The .SQL file that you downloaded was saved incorrectly and had messed up line brakes. Maybe that is what caused it.

Sorry if I'm blind to see the problem, but I'm sitting here re-creating the database structure with my last .SQL file and everything is the way it should be.

Wordplay 10-28-2004 11:54 AM

Lionel can you please rerelease an install script that works? because as it seems nobody was able to really get this to work, right away, and i can't afford my board to not work for a while, it has to work right away.

where should we donate too? once i get it to run on my system i will definately do that, because this hack i've been waiting for.

Lionel 10-28-2004 12:01 PM

here is a snapshot of mysql and the order of the fields

you will see that grouptitle is number2. That is why no one can see it

Lionel 10-28-2004 12:03 PM

Wordplay all you have to do is rearrange the order. I had to do it manually in phpadmin.
Sweedie has a paypal account in first post :-)

and where he says before of after linebreak (there are a ton of them) simply put it in the general permissions group as he stated

Andreas 10-28-2004 12:06 PM

@swedie
I'd suggest to use complete INSERTs to avoid problems with different column ordering.

Eg.

[sql]INSERT INTO foobar (foo, bar) VALUES ('foo', 'bar')[/sql]

oldfan 10-28-2004 03:11 PM

/me will install and donate once this a bug free
Thanks for you hard work swedie!!


All times are GMT. The time now is 04:55 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.01594 seconds
  • Memory Usage 1,739KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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