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)

Kamui Shirou 12-31-2002 06:14 AM

i manuelly did the changes to the database cuz the install script didnt work. and i?ve downloaded that file on page 21.
i?ll try your suggestion. thankx a lot.

edit:
my database contains all tables. i did the changes in my database
once more but still doesnt work, also with your weahter.php change it causes the error

PHP Code:

Database error in vBulletin 2.2.9:

Invalid SQLSELECT countryid FROM weather_subdiv WHERE subdivid=
mysql errorYou have an error in your SQL syntax near '' at line 1

mysql error number
1064

Date
Tuesday 31st of December 2002 09:06:56 AM
Script
: [url]http://www.mangaboard.com/forums/forums/weather.php?action=modifysettings[/url]
Referer: [url]http://www.mangaboard.com/myvbindex.php[/url] 

my server runs with
PHP/4.2.3
mysql dont exactly know but this shows up in phpmyadmin
Connected with MySQL 3.23.54-log ................

PS: Does the myvbindex show up in the who?s online list?

Tigga 12-31-2002 08:21 AM

Ok, it looks like that the change does fix the first problem, but you get a new error a couple of lines down in the script. It appears something on your server doesn't like the way the script is written. Try uploading the weather.php file I have attached here. It's the exact same, except it has ' ' marks around the variables that it doesn't seem to be pulling right, which should (hopefully) fix the problem. If that doesn't work then I can most likely fix it using a different method.

mYvBindex does not show up on the Who's Online, but it's not hard to change it so it will.

Open your forum/online.php file and look for:
PHP Code:

    case 'index':
      
$userinfo[where] = "$bbtitle <a href='index.php?s=$session[sessionhash]'>Main Index</a>";
      break; 

Right Above that Add:
PHP Code:

    case 'home':
      
$userinfo[where] = "$hometitle <a href='/index.php?s=$session[sessionhash]'>Main Index</a>";
      break; 

Then look for:
PHP Code:

  case 'index.php':
    
$userinfo[activity] = 'index';
    break; 

Directly Above that line Add:
PHP Code:

    $userinfo[activity] = 'home';
    break; 

Note that I'm assuming your myvbindex file is called "index.php" and it's in your root directory. If you've named it something else let me know as the instructions would be slightly different.

Kamui Shirou 12-31-2002 09:54 AM

ok it fixed the main prob but there still a prob arising.
when i wanna choose the german cities there“re none to select.

Tigga 12-31-2002 10:05 AM

There don't seem to be any cities to choose from, for any country. I'd reccomend logging in with phpMyAdmin and checking that your weather_city table is not empty. If so, you should run the weather_city1.sql - weather_city6.sql files there. If that table is not empty, let me know how many records it has in it.

Kamui Shirou 12-31-2002 12:11 PM

yeah i reinstalled the changes in the sql severl times now but still germany and some other didnt want to show up. i think the sql files included in the weather.zip file i downloaded are incomplet.
my weather_city table in the databse has 2.627 records

thankx for helping me ^^

Tigga 12-31-2002 12:17 PM

Yup, that would be your problem. There should be something like 37,000 cities. Where did you download the zip file from? If it wasn't from this thread, here's a link to the zip file I made - https://vborg.vbsupport.ru/attachmen...&postid=318513
You should empty your weather_city table, then be sure to run the queries in all 6 weather_city.sql files.

Kamui Shirou 12-31-2002 12:36 PM

thats exactly the one i downloaded before
i try to split it in more parts

Kamui Shirou 12-31-2002 01:13 PM

k that was the misstake. my hoster database was not gonna suck all at once. so i split them to 3000 record steps.

Wells 01-01-2003 09:53 AM

Happy New Year to all.
Please, I need help!
I do everything and everything is ok.
But myvbindex.php says
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT thread.pollid, thread.open, thread.threadid, thread.replycount, poll.pollid, poll.question, poll.dateline, poll.options, poll.votes, poll.active, poll.numberoptions, poll.timeout, poll.multiple, poll.voters FROM thread LEFT JOIN poll ON (thread.pollid=poll.pollid) WHERE

etc

mysql error number: 1064

but with mysql everything is ok... So I do not know what to do...

Admin CP is ok. MySQL queries is ok, but myvbindex.php not working... [I made changes "full path to your forum on your server" correctly]

Tigga 01-01-2003 09:59 AM

Without seeing the full error I can't tell for sure, but it looks like you have the poll turned on and no Poll Fourm ID specified (or the id isn't set correctly). Double check that and if that's not the reason please post the full error message you get here.


All times are GMT. The time now is 06:21 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.02577 seconds
  • Memory Usage 1,754KB
  • 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
  • (5)bbcode_php_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