I'm creating a php/mysql-based bounty website engine. And I need a few individuals to download the engine, install it and give some feedback on the engines functionality and installation procedure.
I installed it on WAMP but i cannot login as admin (not created?):
WindowsXP SP2 Apache 2.0.61 MySQL 5.0.11 PHP 5.2.5
I should say that the keyword is very difficult to read with the grid.
Bye, TMTisFree
"Never ascribe to malice that which is adequately explained by incompetence." (Napol?on Bonaparte) "I would love to change the world, but they won?t give me the source code." (Unknown)
Did you use the install.php script to create an admin user?
And did you get an error message while creating the admin user from the install page?
1/ Yes I used the install script and the 1st admin user was created without pb.
2/ An other pb: If I try to enter a second one (with/without reloading the page), the script says:
Could not insert user: Duplicate entry '' for key 2
3/In the INSTALL.txt it is said: You must create a directory outside the web path where the webserver has read and write permissions. And then point the $g_keyworddir parameter to that directory. Users won't be able to register if this isn't done.
while in the settings.php file: // Directory where keywords are stored // must be read and writeable by the webserver process // Should not be a directory outside the website path $g_keyworddir = "E:/Web/main/php/keywords/";
Both seems to work, but you should keep explanations consistent. Why not use the PHP temp directory as your file inside $g_keyworddir seems to be deleted once used?
That's all :) Bye, TMTisFree
"Never ascribe to malice that which is adequately explained by incompetence." (Napol?on Bonaparte) "I would love to change the world, but they won?t give me the source code." (Unknown)
2. It will say duplicate key if the username already exists in the database. The username field is protected by a unique key constraint in the database to prevent duplicate entries.
Although it seems weird that it says '' in the brackets, as if there's an entry in the database that has an empty username and you're trying to add a new user with no username.
3. Okey, the comment in the settings file has been updated, no idea where the "not" part came from. You can always set the tmp path there yourself if you want :) The keyword files are not always removed, if the user doesn't visit the site from the same IP after loading the register page then the keyfile isn't removed. I'm going to look into cleaning up the directory from old keyfiles later on, but currently that isn't a priority. Perhaps figure out how to store they keyword in the session instead, I couldn't get that to work so I had to use the file system to store them temporarely.
I've created a version that prints the sql query when storing the user. Can you download and paste the query here?
3. Okey, the comment in the settings file has been updated, no idea where the "not" part came from. You can always set the tmp path there yourself if you want :) The keyword files are not always removed, if the user doesn't visit the site from the same IP after loading the register page then the keyfile isn't removed. I'm going to look into cleaning up the directory from old keyfiles later on, but currently that isn't a priority. Perhaps figure out how to store they keyword in the session instead, I couldn't get that to work so I had to use the file system to store them temporarely.
I've created a version that prints the sql query when storing the user. Can you download and paste the query here?
Ok. I created a new database just to be clean for this side.
Here is the output for the 1st admin: 'tmtisfree relative'INSERT INTO User (AccessLevelID, PaymentOptionID,Username,Password,PaypalEmail,ContactEmail,FullName, HomepageURL,Description,UserIconURL,CreatedDate,PaymentDetails,ValidationString) VALUES (3,0,'','','','','','','','',1196024881,'','')
and for the second: 'tmtisfree2 absolute'INSERT INTO User (AccessLevelID, PaymentOptionID,Username,Password,PaypalEmail,ContactEmail,FullName,HomepageURL ,Description,UserIconURL,CreatedDate,PaymentDetails,ValidationString) VALUES (3,0,'','','','','','','','',1196025052,'','')
with the 'usual':
Could not insert user: Duplicate entry '' for key 2
The registration for a simple user is working perfectly (email sent, validation, etc...)
Hope this helps.
Bye, TMTisFree
[Edit: Shorted a few lines]
Edited by orgin on 2007/11/30 7:26:10
"Never ascribe to malice that which is adequately explained by incompetence." (Napol?on Bonaparte) "I would love to change the world, but they won?t give me the source code." (Unknown)
Okey, it seems the parameters are lost in the function calls for some reason. Must be some difference in the php version or somesuch. I'll check into it later today.
I found out what the problem is. I installed WAMP on my local PC to test it. It seems that it is not possible to use the mysql_real_escape_string() function when using WAMP under windows. It simply returns false and generates a warning, even if passed a legal database resource. Which means that when escaping the username and password (as required before executing the sql query) they are simply replaced by 'false' which is translated to an empty string.
I'll look into how to get that function to work properly under windows.
"Never ascribe to malice that which is adequately explained by incompetence." (Napol?on Bonaparte) "I would love to change the world, but they won?t give me the source code." (Unknown)
If you mean "category" then that is something that each individual site sets up for themselves. There's no point in setting up a comprehensive list of categories on a dev site since all data on it is for testing alone anyway :)
On a blank install there's no categories at all and the user installing has to add the categories that is wanted (more can be added at any time though) on that particular site before proceeding.
If you mean "category" then that is something that each individual site sets up for themselves. There's no point in setting up a comprehensive list of categories on a dev site since all data on it is for testing alone anyway :)
Yup, that's what i meant
Wouldn't it be better then to let the reporter decide which category the project is in - say, leave the field blank and only give hints?
I hope you can import this "test" project as i really would like to file it seriously once the "test" site gets real
Okey well, I suppose I could add a comment field where the submitter can give comments to the admin/moderator. Such as suggesting a new category or somesuch. I'll add that to the todo list.
Mind you that I have no intention of running a final site myself, I'm hoping one of the existing sites would be interested in using my engine.