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)

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
@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.

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


All times are GMT. The time now is 07:33 AM.

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.01433 seconds
  • Memory Usage 1,736KB
  • 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_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