vb.org Archive
Page 7 of 12 « First 56 7 89 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - VBNow: twitter.com equivalent for vbulletin (https://vborg.vbsupport.ru/showthread.php?t=155945)

stonyarc 08-25-2007 10:15 PM
Quote:
Originally Posted by Endurer (Post 1325694)
I am getting an SQL error:



I ran the installer but it didn't create the table. Should I reimport the product?

Edit: reimport didn't work.
You need to reinstall the product.

For uninstall it so it cleanly drops the tables. Did you accidently drop the table, as that seems to be the only way you can get that error.

Endurer 08-26-2007 03:56 AM
I did a clean install again. The no-permission page came up for the first time. Then I went ahead to usergroup permissions to allow access, rebuilt bitfields, visited the vbnow application and the error is there again. Seems like something is dropping the table or it's not being created at all. Whats interesting to note is that vbnow_friends and vbnow_profile tables are being created. It's just the vbnow table that's causing problems.

stonyarc 08-26-2007 08:02 AM
Quote:
Originally Posted by Endurer (Post 1325824)
I did a clean install again. The no-permission page came up for the first time. Then I went ahead to usergroup permissions to allow access, rebuilt bitfields, visited the vbnow application and the error is there again. Seems like something is dropping the table or it's not being created at all. Whats interesting to note is that vbnow_friends and vbnow_profile tables are being created. It's just the vbnow table that's causing problems.

That part hasn't changed since the initial release.

Please uninstall the product and check if there are tables left (shouldn't be, if so drop) before reinstalling. If that doesn't work run the query manually (you need to edit it before being able to run in phpmyadmin)

Endurer 08-27-2007 03:10 AM
I tried to run the query and here's the error that I've received from phpmyadmin:

Quote:
Error
SQL query:
CREATE TABLE `vbnow` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`itimestamp` int( 11 ) NOT NULL ,
`message` mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`url` varchar( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`updated` int( 11 ) NOT NULL default '0',
`utimestamp` int( 11 ) NOT NULL ,
`userid` int( 11 ) NOT NULL ,
`views` int( 11 ) NOT NULL ,
`archived` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `updated` ( `updated` , `userid` , `url` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =2

MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set utf8 collate utf8_unicode_ci NOT NULL,
`url` v

stonyarc 08-27-2007 09:39 AM
On my server that runs fine. strange

Endurer 08-27-2007 09:47 AM
Yes, it's pretty strange because it's working on my PC too. My MySQL version on server is: 4.0.27-standard

and as per mySQL:

Quote:
As of MySQL 4.1, character data types (CHAR, VARCHAR, TEXT) can include CHARACTER SET and COLLATE attributes ...
Any alternatives?

Endurer 08-30-2007 02:11 PM
Any solutions stonyarc? I am pretty desperate to get it running on my website.

stonyarc 08-31-2007 08:18 AM
Quote:
Originally Posted by Endurer (Post 1328891)
Any solutions stonyarc? I am pretty desperate to get it running on my website.
You can create the tables manually as long as you respect the names and settings but it's strange you are the only one reporting this. Has to be a setting somewhere.

Sirtis 09-02-2007 10:42 AM
very fine hack

teach1st 09-02-2007 11:10 AM
Quote:
Originally Posted by stonyarc (Post 1329358)
You can create the tables manually as long as you respect the names and settings but it's strange you are the only one reporting this. Has to be a setting somewhere.
I get the same errors and symptoms as Endurer. Uninstall/reinstall doesn't work (vbnow tables were dropped on uninstall). I get the same errors when trying to manually create the vbnow table. MySQL 4.0.27, vBulletin 3.6.8


All times are GMT. The time now is 01:08 PM.
Page 7 of 12 « First 56 7 89 Last »
Show 40 post(s) from this thread on one page

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.01436 seconds
  • Memory Usage 1,740KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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