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 - vHosting Lite (https://vborg.vbsupport.ru/showthread.php?t=124604)

BETIServices 08-24-2006 11:03 PM

Now I'm getting the following:

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
CREATE TABLE `temp_host_request` (
 `
requestidmediumint(10unsigned NOT NULL auto_increment,
 `
useridint(20unsigned NOT NULL default '',
 `
planidint(20unsigned NOT NULL default '',
 `
titlevarchar(120NOT NULL default '',
 `
subdomainvarchar(200NOT NULL default '',
 `
host_usernamevarchar(200NOT NULL default '',
 `
host_passwordvarchar(7NOT NULL default '',
 
PRIMARY KEY  (`requestid`)
);;

MySQL Error  Invalid default value for 'userid'
Error Number 1067
Date         
ThursdayAugust 24th 2006 07:59:48 PM 


BETIServices 08-24-2006 11:04 PM

Another Error:

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
CREATE TABLE `hosting_plans` (
 `
planidmediumint(10unsigned NOT NULL auto_increment,
 `
titlevarchar(120NOT NULL default '',
 `
postsvarchar(120NOT NULL default '',
 `
webspacevarchar(120NOT NULL default '',
 `
transfervarchar(120NOT NULL default '',
 `
emailvarchar(120NOT NULL default '',
 `
ftpvarchar(120NOT NULL default '',
 `
subdomainvarchar(120NOT NULL default '',
 `
mysqldatabasesvarchar(120NOT NULL default '',
 `
addonvarchar(120NOT NULL default '',
 `
parkedvarchar(120NOT NULL default '',
 
PRIMARY KEY  (`planid`)
);;

MySQL Error  Table 'hosting_plans' already exists
Error Number 
1050
Date         
ThursdayAugust 24th 2006 07:55:13 PM 


harmor19 08-24-2006 11:36 PM

Quote:

Originally Posted by BETIServices
Now I'm getting the following:

PHP Code:

Database error in vBulletin 3.6.0:

Invalid SQL:
CREATE TABLE `temp_host_request` (
 `
requestidmediumint(10unsigned NOT NULL auto_increment,
 `
useridint(20unsigned NOT NULL default '',
 `
planidint(20unsigned NOT NULL default '',
 `
titlevarchar(120NOT NULL default '',
 `
subdomainvarchar(200NOT NULL default '',
 `
host_usernamevarchar(200NOT NULL default '',
 `
host_passwordvarchar(7NOT NULL default '',
 
PRIMARY KEY  (`requestid`)
);;

MySQL Error  Invalid default value for 'userid'
Error Number 1067
Date         
ThursdayAugust 24th 2006 07:59:48 PM 


I guess it needs a value.

First run the "uninstall_hosting.xml" again. Download the attachment in this post and import it as a product.

BETIServices 08-25-2006 02:13 AM

Quote:

Originally Posted by harmor19
I guess it needs a value.

First run the "uninstall_hosting.xml" again. Download the attachment in this post and import it as a product.

Yes, install is o.k now :D

harmor19 08-25-2006 02:15 AM

Quote:

Originally Posted by BETIServices
Yes, install is o.k now :D

Glad to hear it.

Please click the "Install" button. It's located below the page navigation.

BETIServices 08-25-2006 02:18 AM

Well new problem, I click on Hosting Options:
Them I get the following:
Quote:

Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel.

I go to the Administrator Permissions section and select Can Administer Hosting to yes but it will not do anything

Yes, I will click install as soon is installed. :D

harmor19 08-25-2006 02:23 AM

Quote:

Originally Posted by BETIServices
Well new problem, I click on Hosting Options:
Them I get the following:



I go to the Administrator Permissions section and select Can Administer Hosting to yes but it will not do anything

Yes, I will click install as soon is installed. :D

Make sure you have uploaded the files in the xml folder to public_html/forum_root/includes/xml/

Make sure you have updated the bitfields. It explains how in the instructions.

BETIServices 08-25-2006 02:38 AM

I had done all that:

here is another error:

Quote:

Database error in vBulletin 3.6.0:

Invalid SQL:
UPDATE administrator SET
### Bitfield: administrator.adminpermissions ###
adminpermissions = IF(adminpermissions & 4, adminpermissions, adminpermissions + 4),
adminpermissions = IF(adminpermissions & 8, adminpermissions, adminpermissions + 8),
adminpermissions = IF(adminpermissions & 16, adminpermissions, adminpermissions + 16),
adminpermissions = IF(adminpermissions & 32, adminpermissions, adminpermissions + 32),
adminpermissions = IF(adminpermissions & 64, adminpermissions, adminpermissions + 64),
adminpermissions = IF(adminpermissions & 128, adminpermissions, adminpermissions + 128),
adminpermissions = IF(adminpermissions & 256, adminpermissions, adminpermissions + 256),
adminpermissions = IF(adminpermissions & 512, adminpermissions, adminpermissions + 512),
adminpermissions = IF(adminpermissions & 1024, adminpermissions, adminpermissions + 1024),
adminpermissions = IF(adminpermissions & 2048, adminpermissions, adminpermissions + 2048),
adminpermissions = IF(adminpermissions & 4096, adminpermissions, adminpermissions + 4096),
adminpermissions = IF(adminpermissions & 8192, adminpermissions, adminpermissions + 8192),
adminpermissions = IF(adminpermissions & 16384, adminpermissions, adminpermissions + 16384),
adminpermissions = IF(adminpermissions & 65536, adminpermissions, adminpermissions + 65536),
adminpermissions = IF(adminpermissions & 32768, adminpermissions, adminpermissions + 32768),
### Bitfield: administrator.hostingadminperms ###
hostingadminperms = IF(hostingadminperms & 1, hostingadminperms, hostingadminperms + 1),
cssprefs = 'vBulletin_3_Manual'
WHERE userid = 1;

MySQL Error : Unknown column 'hostingadminperms' in 'field list'
Error Number : 1054
Date : Thursday, August 24th 2006 @ 11:37:36 PM

harmor19 08-25-2006 02:53 AM

Let's try this again shall we.

Uninstall vHosting from your product manager and import the attached version.
You'll need to update the bitfields again.

BETIServices 08-25-2006 04:28 AM

Did not work either!

Maybe attaching some pictures for you will help!

Pictures attached:
Attachment 52640

Attachment 52641

Attachment 52642


All times are GMT. The time now is 11:03 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.01164 seconds
  • Memory Usage 1,782KB
  • 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_php_printable
  • (6)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