vb.org Archive
Page 16 of 25 « First 61415 16 1718 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Yet Another Awards System [1.2.1] (https://vborg.vbsupport.ru/showthread.php?t=78934)

anarchystar 04-25-2005 01:08 PM
I have been trying to install this hack on 3.0.7, I keep getting MySQL errors at step 3 when it runs the queries. It says I have an error near ';' on line 10, error 1064 as soon as the first query is run on my database. (MySQL vs. 3.23.58, PHP 4.3.8)
I tried 3 times, any suggestions?

Polo 04-25-2005 01:24 PM
Quote:
Originally Posted by anarchystar
I have been trying to install this hack on 3.0.7, I keep getting MySQL errors at step 3 when it runs the queries. It says I have an error near ';' on line 10, error 1064 as soon as the first query is run on my database. (MySQL vs. 3.23.58, PHP 4.3.8)
I tried 3 times, any suggestions?
i would suggest, putting the exact error you are getting here so that the original coder can help you out...

trulylowcarb 04-25-2005 02:37 PM
Upgraded last night.
Wanted to note for you that in the file mods install file, shouldn't the last one actually be performed on functions_online.php?? It references the private.php file again, but the text that you want changed was not in my private.php file. It was in the functions file, however, and changing it there seems to have worked.

Thanks again! :)
Psssst - Voted for you for HOTM also.

mtha 04-25-2005 04:22 PM
Quote:
Originally Posted by anarchystar
I have been trying to install this hack on 3.0.7, I keep getting MySQL errors at step 3 when it runs the queries. It says I have an error near ';' on line 10, error 1064 as soon as the first query is run on my database. (MySQL vs. 3.23.58, PHP 4.3.8)
I tried 3 times, any suggestions?
you may got the old installer file, or I put the wrong one in there by mistake? just to make sure, I uploaded the installer again in the zip file. You can download and install again. For safe, you can run uninstall before install, to remove any pre-added information. or run upgrade.

if you get same error, check the installer that you were running, make sure that there's no ; in lines 606, 618, 631

Quote:
Upgraded last night.
Wanted to note for you that in the file mods install file, shouldn't the last one actually be performed on functions_online.php?? It references the private.php file again, but the text that you want changed was not in my private.php file. It was in the functions file, however, and changing it there seems to have worked.
did you get the latest file? I think I did change it to function_online. :) anyway, you got it working.

Quote:
Psssst - Voted for you for HOTM also.
psssst, thanks :D

anarchystar 04-25-2005 08:48 PM
Hey I tried the install again, I still got the same error. I copied it this time so you could see exactly what it did:

Code:
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE anarchystar_award (
                          award_id smallint(5) unsigned NOT NULL auto_increment,
                          award_cat_id smallint(5) NOT NULL default '1',
                          award_name varchar(50) NOT NULL default '',
                          award_desc varchar(250) NOT NULL default '',
                          award_icon_url varchar(250) NOT NULL default '',
                          award_img_url varchar(225) NOT NULL default '',
                          award_displayorder smallint(5) NOT NULL default '0',
                          PRIMARY KEY  (award_id)
                        ) TYPE=MyISAM;
               
mysql error: You have an error in your SQL syntax near ';
                ' at line 10

mysql error number: 1064

Date: Monday 25th of April 2005 05:44:39 PM
Script: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=doqueries
Referer: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=dotemplates

mtha 04-26-2005 06:46 AM
Quote:
Originally Posted by anarchystar
Hey I tried the install again, I still got the same error. I copied it this time so you could see exactly what it did:

Code:
Database error in vBulletin 3.0.7:
..
                          PRIMARY KEY  (award_id)
                        ) TYPE=MyISAM;
               
mysql error: You have an error in your SQL syntax near ';
                ' at line 10
From this code here, can I say that you did not download the zip file again, and did not upload the new awards_install.php file to your server?

could you PLEASE download the zip file from the first post, unzip, and upload the awards_install.php to your admincp folder.

or I just upload one here. Please upload this file to your server.

anarchystar 04-26-2005 07:23 AM
actually I did, I went back after you posted, downloaded the new package and tried to install. Maybe I still had the old one though and screwed up, I will give it another shot :P .. thanks

mtha 04-26-2005 07:29 AM
Quote:
Originally Posted by anarchystar
actually I did, I went back after you posted, downloaded the new package and tried to install. Maybe I still had the old one though and screwed up, I will give it another shot :P .. thanks
or maybe the old zip file was cached in your computer. sometime you need to clean cache, or download the php file I attached above.

anarchystar 04-26-2005 07:42 AM
it went a little better this time, the tables were added, but it hung up again here:
Code:
Database error in vBulletin 3.0.7:

Invalid SQL:
                        INSERT INTO anarchystar_award_cat
                                (award_cat_id, award_cat_title, award_cat_desc, award_cat_displayorder, award_cat_parentid)
                        VALUES (1, 'Default', 'Default category', 1, -1);
               
mysql error: You have an error in your SQL syntax near ';
                ' at line 4

mysql error number: 1064

Date: Tuesday 26th of April 2005 04:38:51 AM
Script: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=doqueries
Referer: http://forums.anarchystar.com/admincp/awards_install.php?do=install&step=dotemplates
wha'cha think?

anarchystar 04-26-2005 07:49 AM
I opened up you install file, removed that ';' at the last step and it worked like a charm ... good stuff :D


All times are GMT. The time now is 06:28 PM.
Page 16 of 25 « First 61415 16 1718 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.01403 seconds
  • Memory Usage 1,751KB
  • 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_code_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