View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000138 | WackoWiki | installer | public | 2007-12-18 16:34 | 2009-08-19 09:39 |
| Reporter | kle_py | Assigned To | Tann San | ||
| Priority | normal | Severity | crash | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.2 | ||||
| Target Version | 4.3.rc | Fixed in Version | 4.3.rc | ||
| Summary | 0000138: install using PDO sqlite hangs | ||||
| Description | when installing, selecting PDO sqlite or PDO slite2, (using spanish interface, running on Fedora 7 with Apache httpd-2.2.6-1.fc7, PHP 524 php-pdo-5.2.4-1.fc7, sqlite-3.4.2-1.fc7) the installer seems to hang. when entering again in the page i am asked to fill out everything again, and get a message (cited below as additional info). All the directory and file rights of the /var/www/html/test/wacko directory are set to 777, I also tried starting with a prepared empty sqlite database in the same directory, but no difference. When executing the install assistent always an empty file is created which contains the "database name". If i made a mistake with my supplied parametres, maybe You could give me a hint, thanks, Klemens | ||||
| Additional Information | File created in /var/www/html/test/wacko (my testing directory) dbname=wack.db;host=localhost message received by http://localhost/test/wacko/?installAction=install Test de la configuración Test de los parametros de conexión database... OK Installando cosillas page tabla(s) creadas... FRACASO: Ya existe ? revision tabla(s) creadas... FRACASO: Ya existe ? ACL tabla(s) creadas... FRACASO: Ya existe ? link tracking tabla(s) creadas... FRACASO: Ya existe ? referrer tabla(s) creadas... FRACASO: Ya existe ? user tabla(s) creadas... FRACASO: Ya existe ? watches tabla(s) creadas... FRACASO: Ya existe ? upload tabla(s) creadas... FRACASO: Ya existe ? cache tabla(s) creadas... FRACASO: Ya existe ? Añadiendo el usuario administrador... FRACASO: Hmm! Añadiendo algunas páginas... OK | ||||
| Tags | No tags attached. | ||||
|
|
I'll install SQL Lite and give it a try. I've only tested the PDO module with MySQL, MS SQL and PostgreSQL. It's very strange that it is creating all the tables and inserting the other data but crashes when adding the admin. It could be because the admin user has already been created and it isn't allowing you to create a second user with the same name. At what point is the installer hanging? Is it after you've filled out all the information and clicked the submit button? What information did you use for the initial form? Could you post it all and I'll test it out here with the same settings. |
|
|
I would like to comment your note: in the installation page the only items that (seem to) work are: - test of parameters for database connection and - adding some pages (the last line) all other lines say they have failed for some reason (table creation, admin user creation) the point is that after submitting the form i see a page of diagnostic messages, but can go nowhere afterwards (there is no link). No database is created, nor used an existing one, instead a new file appears in the website directory. It has size 0 (zero) and its name looks like a connection parameter. I can enter the site again, but the installer starts up again. |
|
|
Avoiding Headaches When Switching to PHP Data Objects (PDO) http://www.inovaone.com/blog/?p=25 (?) |
|
|
Note: most of the core classes are not abstracted from MySQL specific code yet + requires vendor specific setup scripts for database |
|
|
PDO MySQL seems to be running fine. Tested it installing and running. Next test will be PDO PG SQL. |
|
|
PDO PG SQL fails to install. Don't know how I ever got this to work before since it requires totally different column data types. I've got the "pages" table translated to PGSQL format and will do the rest later in the week. Previously because we couldn't use the try/catch PHP5 system in PHP4 we had to comment it out which meant we had no effective method of checking if PDO access was actually working. I realised today that I could easily stick that bit in an external file which only gets loaded if they have the PDO extension installed which in turn would imply they had PHP5 or greater installed. What does all of that mean? It means that whilst it would say it had successfully tested the PDO connection string in reality it might of failed and just not reported it. Now it properly outputs the PDO error. I think I'm going to split the installer up into several database related files and include them as necessary. The reason for this is that I anticipate each of the PDO databases having different column data types in the way that PGSQL is different than MySQL. Any that are the same will just include the same file so it's not a massive change to what we have now. It will also make the main install.php file cleaner to read through. I get what the fetchColumn error is about and will address it shortly when I finish the other installer db stuff. |
|
|
So is this a complete list of all the most up-to-date table creates? If so then I'll switch over to looking at the "most of the core classes and actions are not abstracted from MySQL specific code" issues. |
|
|
also; you didn't have to rename fields like user001, you could of just escaped the quotes. It will only take about an hour to redo all the SQL including the default values so I'll do that over again for the sake of it :¬) |
|
|
New installer has been implemented. For now we only support legacy MySQL, legacy MySQLi and PDO MySQL. Other PDO dsns will be added in the near future with MS SQL, SQL Lite and PG SQL at the top of the list. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2007-12-18 16:34 | kle_py | New Issue | |
| 2007-12-18 16:34 | kle_py | Legacy | => NEW |
| 2007-12-18 19:02 | administrator | Target Version | => 5.0.0 |
| 2007-12-18 19:02 | administrator | Summary | install using DBO sqlite hangs => install using PDO sqlite hangs |
| 2007-12-19 15:32 | Tann San | Note Added: 0000254 | |
| 2007-12-19 15:32 | Tann San | Status | new => assigned |
| 2007-12-19 15:32 | Tann San | Assigned To | => Tann San |
| 2007-12-20 16:50 | kle_py | Note Added: 0000266 | |
| 2007-12-20 16:55 | kle_py | Note Edited: 0000266 | |
| 2008-02-19 20:42 | administrator | Note Added: 0000285 | |
| 2008-03-22 13:44 | administrator | Note Added: 0000287 | |
| 2008-04-08 12:17 | Tann San | Note Added: 0000306 | |
| 2008-04-08 13:48 | Tann San | Note Added: 0000307 | |
| 2008-04-08 14:00 | administrator | Note Edited: 0000287 | |
| 2008-04-08 14:36 | Tann San | Note Added: 0000309 | |
| 2008-04-08 14:39 | Tann San | Note Added: 0000310 | |
| 2008-06-04 21:29 | Tann San | Status | assigned => resolved |
| 2008-06-04 21:29 | Tann San | Fixed in Version | => 5.0.0 |
| 2008-06-04 21:29 | Tann San | Resolution | open => fixed |
| 2008-06-04 21:29 | Tann San | Note Added: 0000349 | |
| 2009-08-19 09:22 | administrator | Fixed in Version | 5.0.0 => 4.3.rc |
| 2009-08-19 09:39 | administrator | Target Version | 5.0.0 => 4.3.rc |
| 2010-03-08 10:14 | administrator | Category | Installer => installer |
