I checked the setup file and it is set to true for the auto complete. But when i conduct a draft and type in the first 2 letters of a name nothing appears or 'auto completes'. Is there something else i have to do?
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can't really help you on YouTube - the interface is still really clunky and hard to navigate to pass messages between users. I suggested that you remove the database altogether and try to start anew - removing the line from the SQL that gave you troubles. I'm thinking that it gave you issues and the pro_players were not loaded correctly.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Well I changed hosting to the same you are using and reinstalled everything. I even did the sql files from the 0.9 database_initialize and each one there after. Still no autocomplete showing up. Is there a setting in cpanel that has to be enabled to use the script?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I also tried to update the pro_players database with the csv files, but when I go to click the update proplayers button a pop up appears saying that I have chosen to open control_panel.php "what should firefox do with this file?" I click cancel then it does nothing.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
well ive tried everything i can think of. Database looks good for pro_players. Im able to write to database and retrieve from with my drafts. draftboard will update. Just cant get the script to show the names after putting 2 letters in the name field. ive switched hosting sites reinstalled sql file and even tried on another domain. no luck. oh well. still a good script. Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
PHPDraft is written such that you should only be running the "database_initalize.sql" script, don't run any of the other SQL scripts in the sub folder - that's for PHPDraft installs that are upgrading and not a new install like what you have. As for the popup in Firefox… That's curious, not sure why that occurs - I develop for Firefox so it might be a new issue.
If you have the time, can you answer these following questions for me?
-What version of Firefox are you using?
-In PHPMyAdmin, what # of rows is listed for your pro_players database?
-If you're comfortable with doing so, I can look at your install myself and see if I can diagnose the issue - I can send you my email address so you can email me the web address.
I apologize for you having such a tough time, I really want this to work for you!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
So, I have it figured out and it was really quite a silly error - I was overlooking it and missed it completely.
If you're upgrading your PHPDraft install, I'd recommend upgrading this way:
1. Goto the /includes folder, make a copy of global_setup.php (let's call it global_setup_old.php)
2. Upload and overwrite the contents of EVERYTHING in the PHPDraft folder (views, models, includes, etc. everything!)
3. Open up the new global_setup.php, and copy over your database connection information from global_setup_old.php, then upload these changes.
Also, if you have the NFL rosters from last year, go to Control Panel - Update Pro Players Database. Select "National Football League (NFL) for Sports League, then choose /resources/ProPlayers_NFLStandard_2012.csv and upload it. You'll have the latest rosters as of today.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I checked the setup file and it is set to true for the auto complete. But when i conduct a draft and type in the first 2 letters of a name nothing appears or 'auto completes'. Is there something else i have to do?
Thanks
I can't really help you on YouTube - the interface is still really clunky and hard to navigate to pass messages between users. I suggested that you remove the database altogether and try to start anew - removing the line from the SQL that gave you troubles. I'm thinking that it gave you issues and the pro_players were not loaded correctly.
ok…I will try that and let you know how it goes…also looking into the different hosting like you suggested. Thanks
Well I changed hosting to the same you are using and reinstalled everything. I even did the sql files from the 0.9 database_initialize and each one there after. Still no autocomplete showing up. Is there a setting in cpanel that has to be enabled to use the script?
I also tried to update the pro_players database with the csv files, but when I go to click the update proplayers button a pop up appears saying that I have chosen to open control_panel.php "what should firefox do with this file?" I click cancel then it does nothing.
well ive tried everything i can think of. Database looks good for pro_players. Im able to write to database and retrieve from with my drafts. draftboard will update. Just cant get the script to show the names after putting 2 letters in the name field. ive switched hosting sites reinstalled sql file and even tried on another domain. no luck. oh well. still a good script. Thanks
PHPDraft is written such that you should only be running the "database_initalize.sql" script, don't run any of the other SQL scripts in the sub folder - that's for PHPDraft installs that are upgrading and not a new install like what you have. As for the popup in Firefox… That's curious, not sure why that occurs - I develop for Firefox so it might be a new issue.
If you have the time, can you answer these following questions for me?
-What version of Firefox are you using?
-In PHPMyAdmin, what # of rows is listed for your pro_players database?
-If you're comfortable with doing so, I can look at your install myself and see if I can diagnose the issue - I can send you my email address so you can email me the web address.
I apologize for you having such a tough time, I really want this to work for you!
Hey thanks for the help again. I sent you a message.
I'm also having the same problem…everything is working except the auto-complete. Any tips on getting it to work?
I'll be looking at this again, but it was a stumper. I gave up on it for the time being, but I'm starting to get back into it.
So, I have it figured out and it was really quite a silly error - I was overlooking it and missed it completely.
If you're upgrading your PHPDraft install, I'd recommend upgrading this way:
1. Goto the /includes folder, make a copy of global_setup.php (let's call it global_setup_old.php)
2. Upload and overwrite the contents of EVERYTHING in the PHPDraft folder (views, models, includes, etc. everything!)
3. Open up the new global_setup.php, and copy over your database connection information from global_setup_old.php, then upload these changes.
Also, if you have the NFL rosters from last year, go to Control Panel - Update Pro Players Database. Select "National Football League (NFL) for Sports League, then choose /resources/ProPlayers_NFLStandard_2012.csv and upload it. You'll have the latest rosters as of today.