oops, I meant to say /install/

2 things :

1) there is a small typo " their" should be"there" see attached picture.

2) i have set the cron as stated above and scheduled task to run 1 time per day however it still send the same applicant form to moderators forum non stop any idea how to fix this?

thank you.

I am not sure, but it seems to me the problem with the installation of HIS is associated with MySQL version 3.23 while it didn't affect version 4 and above.. ( I tested it on another site and it ran smoothly like a charm)..

Can you confirm it MarcoH64

yup theirs a problem with HIS or atleast my implemation and pre-4.0.0

Try running the following queries, insert table prefix if needed:
[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)
);[/sql]
[sql]CREATE TABLE maf_ratings (
ratingid int(10) NOT NULL auto_increment,
appid int(10) NOT NULL default 0,
userid int(10) NOT NULL default 0,
rating tinyint(4) NOT NULL default 0,
additional_comments mediumtext NOT NULL,
timestamp int(10) NOT NULL default 0,
PRIMARY KEY (ratingid),
KEY appid (appid),
KEY appid_2 (appid)
);[/sql]

@sabre
Why are you not using TABLE_PREFIX? and why the same KEY twice on the second table?

The database errors are not caused by HIS, but by the SQL statements themself. The problem with the current HIS version is that it doesn't show the database error correct.

I ran the SQL query from "phpMyAdmin 2.4.0" as instructed, but there was an error after each query:

after the 1st query
and then after the 2nd query:

Any ideas MarchH64 ?

Well something went wrong with the copy&paste. If you look at the query i posted on the previous page you will see a space between every 'default 0', this turns into 'default0' at your post.

Try again, but insert a space in every 'default0'.

Nice Modification sabretooth.. I will give this a try :)

Regards,

I tried to copy&paster several times, and even added extra spaces, but phpMyAdmin didn't get it right.. so I tried something else..

I inserted the tables manually, and the script worked 80% except for the automatic thread creation.. I think the reason was that I didn't know how to run the following command manually: ( I am still novice @ MySQL quries :o :o )
if thats the reason, can you help me.. I know that I bugged you very much.. but I liked the script and will do anything to install it..