vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   mYvBindex v3.1 (https://vborg.vbsupport.ru/showthread.php?t=44691)

Tigga 11-22-2002 06:25 PM

Did you set the cookie path to your domain name as instructed in the install file? What is the url to your site?

Tony DiMera 11-23-2002 10:27 PM

Quote:

Originally posted by PlurPlanet
Ok, here is a zip file with all the queries that you can do in phpMyAdmin. You will want to open each text file included, copy and paste them into phpMyAdmin and run the queries.
Be sure to run the queries in the "create_tables.txt" file FIRST. Then run the queries listed in the other .txt files (it doesn't matter what order) individually. Each of those queries will probably take a few minutes to execute. After those are finished you should upload the weather_template.php to your fourms/admin folder and run that in your browser. That is just a small file that will install all the templates for you. After that you can go into your Admin CP and turn the weather on under your mYvBindex options.

I did that but for what was in this txt file:

PHP Code:

CREATE TABLE weather_country (
  
countryid smallint(6NOT NULL auto_increment,
  
regionid smallint(6NOT NULL default '0',
  
country_title varchar(50NOT NULL default '',
  
PRIMARY KEY  (countryid)
TYPE=MyISAM

I got this error:

PHP Code:

Error 
SQL
-query :  [Edit

CREATE TABLE `weather_country` (`countryidSMALLINT(6NOT NULL AUTO_INCREMENT, `regionidSMALLINT(6) DEFAULT '0' NOT NULL, `country_titleVARCHAR(50NOT NULL TYPE MYISAM comment 'PRIMARY KEY  (countryid)'

MySQL said


Incorrect table definitionThere can only be one auto column and it must be defined as a key

Back 


Tony DiMera 11-26-2002 07:49 PM

*bump*

snout 11-30-2002 02:44 PM

Thanks for the hack m8... Ill check it out, look loads better than version 1 !!

*hits install*

Tigga 12-01-2002 03:49 AM

Tony - Those queries should work. The only other thing I can suggest is checking the Weather Mk thread and downloading the queries from there. One note though - I've had the weather turned off for my homepage for the last 2 weeks now. It's hardly been working, and even when it did it would cause my homepage to take 10-20 seconds to load. I think they changed the settings at theweatherchannel.com because their site's still working, but not the script. Once I have the time I may see if I can write a new one.

Snout - Thanks for installing. :)

3dfly 12-01-2002 04:22 AM

PlurPlanet thank you for the hack!!!
BEST ! And without hysterics about (?) and pirates ........ ???? :)
Ill check it out tomorow.

corsacrazy 12-01-2002 06:40 PM

no news showing up and yes i followed every step and have uploaded new thread and reply, however when i do upload these files i cant post a reply nor a thread i hav double checked and the file mods have been done correctly and the isnews row does exist i just cant work it out, could it be something to do with other hacks i have installed in these two files ? cheers in advance

Tigga 12-01-2002 07:16 PM

Hmm, that's odd... I noticed in your profile that you have 40 hacks installed, so it is possible that something else could be affecting it. If you would like to email me (brian@plurplanet.com) with your newreply.php and newthread.php files I'll be glad to take a look and see if I can figure it out.
Also, what do you have set for News Forum ID and News Posts Maximum in the admin options? Could you post the url to your myvbindex.php file on the server so I can take a look there too?

Tony DiMera 12-01-2002 10:05 PM

Actually I tried that and it didn't work, could it be my phpMyAdmin version?

Welcome to phpMyAdmin 2.2.0
MySQL 3.23.41 running on localhost

Tigga 12-02-2002 02:07 AM

Try running this query instead...

PHP Code:

CREATE TABLE weather_country (
  
countryid smallint(6NOT NULL auto_increment,
  
regionid smallint(6NOT NULL default '0',
  
country_title varchar(50NOT NULL default '',
  
PRIMARY KEY  (countryid)
TYPE=MyISAM 



All times are GMT. The time now is 02:24 AM.

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