r3193 and younger: problem creating db-tables

saccade · 2009-05-26 09:39:22

New installs since ~~r3195~~ r3193 do not create tables on a local xampp server.
~~r3188~~ r3192 is fine.
But r3195 and r3203/r3204 do not create the tables. DB connect is successful, but then no tables can be found and further installation fails.
Another observation with these revs: Site URL is given differently: It shows the textpattern-path and index.php. Not just the domain as before.

Table creation fails with and without table prefixes.

Here the error messages:

Warning: Table 'txprev.textpattern' doesn't exist describe `textpattern` in D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_db.php on line 82

Warning: Cannot modify header information - headers already sent by (output started at D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_db.php:82) in D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_misc.php on line 1801

Warning: Table 'txprev.txp_page' doesn't exist select user_html from txp_page where name='error_503' in D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_db.php on line 82

Warning: Table 'txprev.txp_page' doesn't exist select user_html from txp_page where name='error_default' in D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_db.php on line 82

Warning: Cannot modify header information - headers already sent by (output started at D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_db.php:82) in D:\werkstatt\xampp\domains\local.txp3204e\web\public\textpattern\lib\txplib_misc.php on line 1863

DB-Connect was succesful, but the textpattern-table was not found.

Last edited by saccade (2009-05-26 12:51:15)

net-carver · 2009-05-26 12:23:45

Michael

Does r3193 work for you? The checkin note for that revision includes this … “As a precondition for multi-site capabilities, make setup location-agnostic”

saccade · 2009-05-26 12:33:45

@net-carver: one moment, I’ll try immediately …

saccade · 2009-05-26 12:37:45

No, it doesn’t. The same error. Now I’ll try r3192.

saccade · 2009-05-26 12:45:57

Steve
r3192 is working, r3193+ doesn’t.
Another observation: The layout is slightly different too. r3193+ has some padding (or so) around and doesnt fill the whole viewport with the yellow line above.
Also: the Site URL is different, pointing to the textpattern subdir.

Thanks for helping!

Last edited by saccade (2009-05-26 12:46:33)

net-carver · 2009-05-26 12:47:17

At least that narrows it down to the r3193 changes. Thanks for testing.

wet · 2009-06-09 06:19:40

At first glance, I cannot reproduce this behaviour.

Questions:

What is the exact file system path to the site’s DocumentRoot (D:\...)?
What is the exact URI to the site’s root as seen from the client (http://...)?
Which Apache version do you use?
Does the setup script ever reach the stage in which it announces:

That went well. Database tables were created and populated.
You should be able to access the main interface with the login and password you chose.
Thank you for your interest in Textpattern.

Please provide a list of all setup steps as they occur, and any deviations from the usual sequence:

Access textpattern/setup/index.php
“Please choose a language”
“Inevitably, we need a few details: MySQL login…”
“Checking database connection… Connected Using $dbname (utf8) Before you proceed, Create a file called config.php…”
“Thank you. You are about to create and populate database tables.”
…time passes… watch the database in phpMyAdmin (or elsewhere) as new tables are created and populated
“That went well. Database tables were created and populated.”
Log in.

saccade · 2009-06-09 09:56:46

Hi, I just tested with r3213 in a new install on local xampp and on a fresh real domain with the same results as before:

Questions:
1) D:\werkstatt\xampp\domains\local.txp408devd\web\public\
2) http://local.txp408devd
3) XAMPP 1.7.1 = Apache HTTPD 2.2.11
4) No.

Steps (see linked screenshots):
1. Access textpattern/setup/index.php OK, but see the gutter — Edit: I left out the /setup/-part
2. “Please choose a language” real OK, but see the gutter
3. “Inevitably, we need a few details: MySQL login…” xampp real OK, but see the gutter, and the site-URL
4. “Checking database connection… Connected Using $dbname (utf8) Before you proceed, Create a file called config.php…” xampp real OK
5. No thanks but 5 resp. 3 warnings and the resume “DB-Connect was succesful, but the textpattern-table was not found.” xampp real

BTW: There is a typo in “succesful”, should read “successful”.

Last edited by saccade (2009-06-09 10:44:08)

wet · 2009-06-09 10:16:20

Edit:

1. Access textpattern/setup/index.php OK, but see the gutter

I think you are accessing textpattern/index.php (without the /setup/ part)?

Otherwise…

We will need a gentle hack to approach this. Please download this file and save it as ../textpattern/setup/index.php, replacing the current version. Browse to http://local.txp408devd/textpattern/setup/ and copy the diagnostic output back here. It will look approximately like that:

txpdir:
array (
  0 => '',
  1 => 'textpattern',
  2 => 'setup',
  3 => 'index.php',
)

txpdir:
/textpattern

=================
PHP_SELF: /textpattern/setup/index.php
rel_siteurl: 
rel_txpurl: /textpattern
=================

Last edited by wet (2009-06-09 10:27:07)

saccade · 2009-06-09 10:31:44

Done.

txpdir:
array (
  0 => '',
  1 => 'textpattern',
  2 => 'setup',
  3 => 'index.php',
)

txpdir:
/textpattern

=================
PHP_SELF: /textpattern/setup/index.php
rel_siteurl: 
rel_txpurl: /textpattern
=================

saccade · 2009-06-09 10:41:37

Ah, now I see something new:
Sorry for leaving out the “setup”.
If using “setup” in the path everything seems to work well.

On the other hand: I’ve set up dozens of installs before without typing “setup” in the url.

wet · 2009-06-09 10:45:06

Yes, it’s a perfectly valid method. I’ve just initially missed it and got to deal with it properly under the light of the new location-agnostic setup environment.

Textpattern CMS

Textpattern CMS support forum

#1 2009-05-26 09:39:22

r3193 and younger: problem creating db-tables

#2 2009-05-26 12:23:45

Re: r3193 and younger: problem creating db-tables

#3 2009-05-26 12:33:45

Re: r3193 and younger: problem creating db-tables

#4 2009-05-26 12:37:45

Re: r3193 and younger: problem creating db-tables

#5 2009-05-26 12:45:57

Re: r3193 and younger: problem creating db-tables

#6 2009-05-26 12:47:17

Re: r3193 and younger: problem creating db-tables

#7 2009-06-09 06:19:40

Re: r3193 and younger: problem creating db-tables

#8 2009-06-09 09:56:46

Re: r3193 and younger: problem creating db-tables

#9 2009-06-09 10:16:20

Re: r3193 and younger: problem creating db-tables

#10 2009-06-09 10:31:44

Re: r3193 and younger: problem creating db-tables

#11 2009-06-09 10:41:37

Re: r3193 and younger: problem creating db-tables

#12 2009-06-09 10:45:06

Re: r3193 and younger: problem creating db-tables

Board footer