vb.org Archive
Page 9 of 44 « First 78 9 101119 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)
-   -   MAF: (Moderator Application Form & Application Rating Module) (https://vborg.vbsupport.ru/showthread.php?t=77340)

Blootix 03-04-2005 01:54 AM
Quote:
Originally Posted by Lionel
Big sigh! I have the same problem with the member choice hack. I have had that problem on 3 different boards.
What is this? I got an error message when I installed this on 3.0.7. This occurs when I go to either ACP or MCP and click on Rate Applications:
Code:
Database error in vBulletin 3.0.7:

Invalid SQL:
                        SELECT maf_application.*, user.username
                        FROM maf_application
                        LEFT JOIN vb3_user ON (user.userid = maf_application.userid)
               
mysql error: Unknown table 'user' in field list

mysql error number: 1109
Anyone else getting this?

Lionel 03-04-2005 02:04 AM
Looks like I am not the only one after all

https://vborg.vbsupport.ru/showthrea...389#post620190

Lionel 03-04-2005 02:14 AM
sabreth00the, how did you get around the same error you reported at
https://vborg.vbsupport.ru/showthrea...389#post611628

Marco van Herwaarden 03-04-2005 06:23 AM
@lionel
The
Code:
Warning: halt(./includes/functions_log_error.php) [function.halt]: failed to create stream: No such file or directory in /var/www/forums/includes/db_mysql.php on line 389
message is a bug in the HIS installer, where it can not display the normal error message if a SQL error occurs. You should find the SQL error however if you ever want to solve your problem.

@all getting errors during install table creations
What MySQL version you're running?
Did you upload the files in binary or ASCII mode?

Marco van Herwaarden 03-04-2005 06:25 AM
@sabre
[sql]SELECT maf_application.*, user.username
FROM maf_application
LEFT JOIN vb3_user ON (user.userid = maf_application.userid)[/sql]
2 problems as i see them:
1. "FROM maf_application" is not using TABLE_PREFIX, and missing a " AS .."
2. "LEFT JOIN vb3_user " should be: "LEFT JOIN vb3_user AS user"

Lionel 03-04-2005 06:57 AM
My files were uploaded in ascii and myql version is 3.23

sabret00the 03-04-2005 07:01 AM
Quote:
Originally Posted by Lionel
every time. twice. And the file is there. And that is a fresh copy of 3.07
give me the greater part of the day and i'll make a text installer for you :)

Lionel 03-04-2005 07:03 AM
and this the db error i got

Quote:
Database error in vBulletin 3.0.7:

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)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 21

mysql error number: 1064

sabret00the 03-04-2005 07:03 AM
Quote:
Originally Posted by MarcoH64
@sabre
[sql]SELECT maf_application.*, user.username
FROM maf_application
LEFT JOIN vb3_user ON (user.userid = maf_application.userid)[/sql]
2 problems as i see them:
1. "FROM maf_application" is not using TABLE_PREFIX, and missing a " AS .."
2. "LEFT JOIN vb3_user " should be: "LEFT JOIN vb3_user AS user"
thanks, i'll get that fixed :)

Lionel 03-04-2005 07:05 AM
Quote:
Originally Posted by sabret00the
give me the greater part of the day and i'll make a text installer for you :)

thanks


All times are GMT. The time now is 07:12 AM.
Page 9 of 44 « First 78 9 101119 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.01609 seconds
  • Memory Usage 1,745KB
  • 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
  • (5)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