vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   MAF: (Moderator Application Form & Application Rating Module) (https://vborg.vbsupport.ru/showthread.php?t=77340)

heynurse 05-10-2005 11:58 PM

I get the following error after clicking the "done" button on the last step of the insall script:
Quote:

Database error in vBulletin 3.0.6:
Invalid SQL: CREATE TABLE maf_application (
appid int(10) NOT NULL auto_increment,
userid int(10) NOT NULL default '0',
email varchar(250) NOT NULL default '',
fullname varchar(250) NOT NULL default '',
age tinyint(4) NOT NULL default '0',
location varchar(250) NOT NULL default '',
timezone varchar(25) NOT NULL default '',
position varchar(250) NOT NULL default '',
why_them mediumtext NOT NULL,
what_they_bring mediumtext NOT NULL,
pactivity mediumtext NOT NULL,
globally_pactivity mediumtext NOT NULL,
plus_site mediumtext NOT NULL,
neg_site mediumtext NOT NULL,
better_than_rest mediumtext NOT NULL,
more mediumtext NOT NULL,
application_time int(10) NOT NULL default '0',
auto_mailed tinyint(4) default NULL,
PRIMARY KEY (appid)
);

mysql error: You have an error in your SQL syntax near ';
' at line 21
mysql error number: 1064
Date: Tuesday 10th of May 2005 07:53:15 PM
This is the error on the webpage as well:
I changed the real path to the forums to: "/path to forums/"

Quote:

Warning: halt(./includes/functions_log_error.php): failed to open stream: No such file or directory in /path to forums/forums/includes/db_mysql.php on line 387

Warning: halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/share/pear') in /path to forums/forums/includes/db_mysql.php on line 387


My server details:
Web Server: Apache v1.3.27
PHP 4.3.4
MySQL: 3.23.58-log

any ideas or suggestions? Thanks

Aceman 05-14-2005 06:56 PM

Will this hack work with PHP 4.3.11??

I'm getting this error:

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO thread(title, lastpost, forumid, open, replycount, postusername, postuserid, lastposter, dateline, visible, sticky)
VALUES ('New Mod Applications To Be Rated', 1116100501, 113, 1, 0, '', , '', 1116100501, 1, 0)

mysql error: 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 ' '', 1116100501, 1, 0)' at line 2

mysql error number: 1064

Date: Saturday 14th of May 2005 07:55:02 PM

Aceman 05-14-2005 07:01 PM

I figured out what it was.. the person or member you specify as your poster for the mod forum MUST EXIST.. I made up a user and it wasn't working.. I put my own username in and now it's humming along nicely.

Aceman

sabret00the 05-14-2005 07:02 PM

Quote:

Originally Posted by Aceman
I figured out what it was.. the person or member you specify as your poster for the mod forum MUST EXIST.. I made up a user and it wasn't working.. I put my own username in and now it's humming along nicely.

Aceman

glad you got it working :)

sabret00the 05-14-2005 07:03 PM

Quote:

Originally Posted by heynurse
I get the following error after clicking the "done" button on the last step of the insall script:


This is the error on the webpage as well:
I changed the real path to the forums to: "/path to forums/"



My server details:
Web Server: Apache v1.3.27
PHP 4.3.4
MySQL: 3.23.58-log

any ideas or suggestions? Thanks

sorry only just saw this, what line was 21?

blueuniverse 05-17-2005 07:21 PM

Am I missing something. I ran the installer file and I got this.

Quote:

MAF


templates.php (Save This File)

<?php

// Templates


Warning: Invalid argument supplied for foreach() in /his_files/hack_creator_b2.php.bak on line 160

?>



phrases.php (Save This File)

<?php

// Phrases

Warning: Invalid argument supplied for foreach() in /his_files/hack_creator_b2.php.bak on line 202

?>




Warning: halt(./includes/functions_log_error.php): failed to open stream: No such file or directory in /home/blueuniv/public_html/rousehousev4/includes/db_mysql.php on line 389

Warning: halt(): Failed opening './includes/functions_log_error.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/blueuniv/public_html/rousehousev4/includes/db_mysql.php on line 389
this was followed by a database error

Quote:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT varname, text FROM phrase WHERE varname IN () ORDER BY languageid DESC
mysql error: 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 ') ORDER BY languageid DESC' at line 1

mysql error number: 1064
Anybody know what might be causing this?

Marco van Herwaarden 05-17-2005 07:35 PM

Don't tick the "Generate Files" in the installer screen.

Watson 05-18-2005 01:41 PM

Getting this error

Code:

Moderator Application


Warning: chdir(): No such file or directory (errno 2) in /includes/cron/maf_cron.php on line 10

But I put in the proper path, my forums are in a sub domain, will this effect it? Cause I really would like the cron job to work, as my posts aint going in a forum :(

edit* This was when I manually ran it, but it seems to create the thread for some reason

sabret00the 05-18-2005 01:58 PM

Quote:

Originally Posted by Watson
Getting this error

Code:

Moderator Application


Warning: chdir(): No such file or directory (errno 2) in /includes/cron/maf_cron.php on line 10

But I put in the proper path, my forums are in a sub domain, will this effect it? Cause I really would like the cron job to work, as my posts aint going in a forum :(

edit* This was when I manually ran it, but it seems to create the thread for some reason

if you put your path in, it really shouldn't matter

"/home/watson/public_html/subdomains/forums/"

Watson 05-19-2005 08:37 AM

yeah seems to work fine anyway, just get that when I manually run the cron :)

Meant to ask, is there anyway to let my mods see the comments that are posted also? and mabye even add more comments, or is there some way if the application is short listed to transfer it onto the forums, to be discussed more?

for the New Version mabye?


All times are GMT. The time now is 05:32 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.04289 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
  • (2)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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