vb.org Archive - MAF: (Moderator Application Form & Application Rating Module)

Page 3 of 11

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

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

sabret00the

03-04-2005 07:06 AM

Quote:

Originally Posted by Lizard King

is the problem with modcp solved ?

Also a question with cron , as I explained before. I just tested application form once cause I had to make some translations over templates. And I ran the cron job and I didn't set a time to run. I have 10 topics now but what I can't understand is if a cron job run once and do his job why is he opening the same topic second time ?
I am not sure if the cron job will re open the thread ? I checked now and he again reopened the thread. Thats is something you must clear urgently cause it will be really disturbing that cron job will do the job again and again which he already did.

Check out the attached screenshot and check the last post time. There is something really wrong with the cron job.

ok for this quite sure what the error is, at the end of the cron script it checks if theirs any new applications, if that case is true then it makes the thread, this isn't in a loop or anything or the sort in order to generate this command more than once, however everytime the script is run it will make a new thread, i can only guess that somehow the script ran ten times.

Marco van Herwaarden

03-04-2005 07:08 AM

I see more people are getting the same SQL error. If i however copy the SQL statement into a SQL-editor, it runs without any problems.

I am running MySQL 4.1.8 myself, you are still on version 3, so that might be the reason for your problems. Would be interesting to see if the other users reporting this error are also running older MySQL versions.

You maybe have access to a server running a higher MySQL version to test?

sabret00the

03-04-2005 07:15 AM

i'm running 4.0.18 on my localhost so i think you're probably right marco

Lionel

03-04-2005 07:16 AM

I've got my own server but I am not sure on how to upgrade to 4.18

sabret00the

03-04-2005 07:23 AM

anyone with modcp/admincp problems can redownload the zip i've got it fixed finally :)

Marco van Herwaarden

03-04-2005 07:31 AM

@lionel
Try to edit the 'queries.php' file in the hacks install directory.

Change the line:
[sql]) TYPE=MyISAM;
[/sql]
to
[sql]);[/sql]
This should probably be done for every CREATE TABLE statement in that file.

Now please check if it runs and report back.

Oblivion Knight

03-04-2005 07:59 AM

For the "This Application Was Rated: 12846 days ago" bug, open up /modcp/maf_rateapp.php and find:
[sql] SELECT maf_ratings.appid, maf_ratings.userid, user.username, maf_ratings.rating, maf_ratings.additional_comments[/sql]On the same line, after it add:
[sql], maf_ratings.timestamp[/sql]All fixed.. :)

Lionel

03-04-2005 08:40 AM

Quote:

Originally Posted by MarcoH64

that did not help at all. Same results.

Lionel

03-04-2005 08:45 AM

Hey, that helped after all. It was missing a single quote brfor the ; like ';

Lionel

03-04-2005 08:56 AM

Thank you marco. Got it up and running

The Realist

03-04-2005 09:34 AM

Changed path in cron,
Setup cron in admin and runs ok,
Made test application,

And nothing shows in my choosen forum ID?

Anyone?

The Realist

03-04-2005 09:41 AM

They ae showing in my choosen forum but I cannot find any place inside the mod panel to moderate the applications.

Quote:

Originally Posted by The Realist

Changed path in cron,
Setup cron in admin and runs ok,
Made test application,

And nothing shows in my choosen forum ID?

Anyone?

Marco van Herwaarden

03-04-2005 09:47 AM

Quote:

Originally Posted by Lionel

Thank you marco. Got it up and running

Nice to see you solved it.

My guess is that you will run into the same problem with loads of other hacks also. Solution would be the same for all.....remove the TYPE=MyISAM or change it to TYPE=ISAM.

I guess everybody still running MySQL 3 will have this problem, i would suggest you look into upgrading.

Lionel

03-04-2005 10:22 AM

I was able to install the member choice hack too, using the same method.

sabret00the

03-04-2005 10:25 AM

Quote:

Originally Posted by Oblivion Knight

For the "This Application Was Rated: 12846 days ago" bug, open up /modcp/maf_rateapp.php and find:

[sql]SELECT maf_ratings.appid, maf_ratings.userid, user.username, maf_ratings.rating, maf_ratings.additional_comments[/sql]

On the same line, after it add:

[sql], maf_ratings.timestamp[/sql]
All fixed..

added that fix, thanks :)

Quote:

Originally Posted by The Realist

They ae showing in my choosen forum but I cannot find any place inside the mod panel to moderate the applications.

moderate the applications? that's not part of this hack, rate em yes, delete em yes, moderate nope.

The Realist

03-04-2005 10:53 AM

Yes but where is this done from?

Can see anything in the mod panel?

Quote:

Originally Posted by sabret00the

added that fix, thanks :)
moderate the applications? that's not part of this hack, rate em yes, delete em yes, moderate nope.

sabret00the

03-04-2005 10:57 AM

Quote:

Originally Posted by The Realist

Yes but where is this done from?

Can see anything in the mod panel?

did you make the edits to modcp/index.php as directed?

sabret00the

03-04-2005 10:58 AM

Quote:

Originally Posted by Lionel

I was able to install the member choice hack too, using the same method.

now you're a happy bunny i don't need to make the text installer do i? :happysad:

The Realist

03-04-2005 10:58 AM

I did not see any instructions for that, blind you see :)

Will have another look.

Quote:

Originally Posted by sabret00the

did you make the edits to modcp/index.php as directed?

The Realist

03-04-2005 11:01 AM

Just had another look at the install file and it says for Click here to view the file/template modifications ONLY -->

No readme files found.

So were are the edits to?

sabret00the

03-04-2005 11:04 AM

Quote:

Originally Posted by The Realist

Just had another look at the install file and it says for Click here to view the file/template modifications ONLY -->

No readme files found.

So were are the edits to?

click the "click here" bit.

yoyoyoyo

03-04-2005 11:14 AM

thanks sabe!

The Realist

03-04-2005 11:18 AM

Yes and it takes me back to the main front page.

Quote:

Originally Posted by sabret00the

click the "click here" bit.

Slybone

03-04-2005 11:18 AM

you know...i recommend that you allow us to add/delete "Questions" in the modd app via admincp, because im sure everyone has different questions they want to ask and what not

aswell as changing the "terms to be a mod"

aswell as an error while testing

Code:

Database error in vBulletin 3.0.6:



Invalid SQL: 

                DELETE * 

                FROM maf_application

                WHERE userid = 588024

        

mysql error: You have an error in your SQL syntax near '* 

                FROM maf_application

                WHERE userid = 588024

        ' at line 2



mysql error number: 1064



Date: Friday 04th of March 2005 07:16:20 AM

Script: http://forums.outwar.com/admin/maf_delapp.php

Referer: http://forums.outwar.com/admin/maf_delapp.php

Username: www_Slybone

IP Address:

Oblivion Knight

03-04-2005 11:29 AM

I have a feeling it may be to do with table prefixes (or lack of)..

Slybone, try the attached files and see if it helps.

sabret00the

03-04-2005 11:45 AM

Quote:

Originally Posted by The Realist

Yes and it takes me back to the main front page.

ok these are the file edits you need to make

in admincp/index.php find

PHP Code:


		
			
    $printhr = false;

    if (can_administer('canadminstyles'))

    {

        $printhr = true;

        construct_nav_option($vbphrase['style_manager'], 'template.php?do=modify', '<br />');

and add above that

PHP Code:


		
			
    // +++ MAF 

    construct_nav_option("Automated Thread Settings", 'options.php?dogroup=maf', '<br />');

    construct_nav_option("Rate Applications", '../' . $modcpdir . 'maf_rateapp.php?do=list', '<br />');

    construct_nav_option("Delete Applications", 'maf_delapp.php?do=del', '<br />');

    construct_nav_group("Moderator Applicants", '<hr />');

    // --- MAF

now in the modcp/index.php find

PHP Code:


		
			
    // *************************************************

    if (can_moderate(0, 'canannounce'))

    {

        construct_nav_option($vbphrase['add_new_announcement'], 'announcement.php?do=add\');

and add above that

PHP Code:


		
			
    // +++ MAF 

    construct_nav_option("Rate Applications", '../' . $modcpdir . '/maf_rateapp.php?do=list', '<br />');

    construct_nav_group("Moderator Applicants", '<hr />');

    // --- MAF

that's it :)

The Realist

03-04-2005 12:22 PM

Thanks for the below all done but when I remove the test applications it gives me a DB error:

Database error in vBulletin 3.0.6:

Invalid SQL:
DELETE *
FROM maf_application
WHERE userid = 1

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 '*
FROM maf_application
WHERE userid = 1' at line 1

mysql error number: 1064

Date: Friday 04th of March 2005 09:20:59 AM
Script: http://www.xxxxxxxx.com/forums/admincp/maf_delapp.php
Referer: http://www.xxxxxxxx.com/forums/admincp/maf_delapp.php

Quote:

Originally Posted by sabret00the

ok these are the file edits you need to make

in admincp/index.php find

PHP Code:


		
			
    $printhr = false;

    if (can_administer('canadminstyles'))

    {

        $printhr = true;

        construct_nav_option($vbphrase['style_manager'], 'template.php?do=modify', '<br />');

and add above that

PHP Code:


		
			
    // +++ MAF 

    construct_nav_option("Automated Thread Settings", 'options.php?dogroup=maf', '<br />');

    construct_nav_option("Rate Applications", '../' . $modcpdir . 'maf_rateapp.php?do=list', '<br />');

    construct_nav_option("Delete Applications", 'maf_delapp.php?do=del', '<br />');

    construct_nav_group("Moderator Applicants", '<hr />');

    // --- MAF

now in the modcp/index.php find

PHP Code:


		
			
    // *************************************************

    if (can_moderate(0, 'canannounce'))

    {

        construct_nav_option($vbphrase['add_new_announcement'], 'announcement.php?do=add\');

and add above that

PHP Code:


		
			
    // +++ MAF 

    construct_nav_option("Rate Applications", '../' . $modcpdir . '/maf_rateapp.php?do=list', '<br />');

    construct_nav_group("Moderator Applicants", '<hr />');

    // --- MAF

that's it :)

Lizard King

03-04-2005 12:43 PM

I get the same database error :)

also this one never worked for me ?

PHP Code:


		
			
construct_nav_option("Rate Applications", '../' . $modcpdir . 'maf_rateapp.php?do=list', '<br />');

I think we have to change that to

PHP Code:


		
			
construct_nav_option("Rate Applications",  'http://www.yoursite.com/forum/modcp/maf_rateapp.php?do=list', '<br />');

sabret00the

03-04-2005 12:57 PM

Quote:

Originally Posted by Lizard King

I get the same database error :)

also this one never worked for me ?

PHP Code:


		
			
construct_nav_option("Rate Applications", '../' . $modcpdir . 'maf_rateapp.php?do=list', '<br />');

I think we have to change that to

PHP Code:


		
			
construct_nav_option("Rate Applications",  'http://www.yoursite.com/forum/modcp/maf_rateapp.php?do=list', '<br />');

depends on your set up the modcp variable is defined in your config.php

either way should work as long as you compensate for the directory.

sabret00the

03-04-2005 01:03 PM

Quote:

Originally Posted by The Realist

replace the admincp file and this should be fixed now :)

All times are GMT. The time now is 04:20 AM.

Page 3 of 11

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01688 seconds Memory Usage 1,879KB 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 (12)bbcode_php_printable (21)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)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
Messages: