[SOLVED] Database connection successful, but textpattern table not.

yawar.aziz · 2021-11-29 10:30:00

Dear Team / Members,

Hope this message finds you well.

I have installed Textpattern 4.8.5 & 4.8.7. Everything goes well until I press “I did it” button after creating config.php in /var/www/html directory. The database doesn’t populate & I find following error:

“Database connection was successful, but the textpattern table was not found.”

After pressing the “I did it” button, I am redirected to the screen showing following error:

Fatal error: Uncaught UnexpectedValueException: RecursiveDirectoryIterator::__construct(/var/www/html/../themes): failed to open dir: No such file or directory in /var/www/html/vendors/Textpattern/Iterator/RecDirIterator.php:55 Stack trace: #0 /var/www/html/vendors/Textpattern/Iterator/RecDirIterator.php(55): RecursiveDirectoryIterator->__construct(‘/var/www/html/….’, 4624) #1 [internal function]: Textpattern\Iterator\RecDirIterator->__construct(‘/var/www/html/….’) #2 /var/www/html/vendors/Textpattern/Container/Container.php(118): ReflectionClass->newInstanceArgs(Array) #3 /var/www/html/vendors/Txp.php(54): Textpattern\Container\Container->getInstance(‘Textpattern\\Ite…’, Array) #4 /var/www/html/vendors/Textpattern/Skin/CommonBase.php(494): Txp::get(‘Textpattern\\Ite…’, ‘/var/www/html/….’) #5 /var/www/html/vendors/Textpattern/Skin/Skin.php(385): Textpattern\Skin\CommonBase->getFiles(Array, 1) #6 /var/www/html/vendors/Textpattern/Skin/Skin.php(410): Textpattern\Skin\Skin->setUploaded() #7 /var/www/html/setup/inde in /var/www/html/vendors/Textpattern/Iterator/RecDirIterator.php on line 55.

Can someone help me out please….

Thank you

Dragondz · 2021-11-29 12:09:54

Hi

The config.php file must be set in /html/textpattern directory

Cheers.

yawar.aziz · 2021-11-30 05:15:36

Dear Moderator,

Thank you very much for a early response.

My /var/www/html has Textpattern-4.8.5 directory. There is another directory named textpattern in it. I moved textpattern-4.8.5/textpattern directory to /var/www/html & also index.php too, but when I access my textpattern/setup/index.php through browser & setup the initial parameters in my config.php file as under:

<?php
$txpcfg[‘db’] = ‘cms_db’;
$txpcfg[‘user’] = ‘xxx’;
$txpcfg[‘pass’] = ‘xxxx’;
$txpcfg[‘host’] = ‘localhost’;
$txpcfg[‘table_prefix’] = ‘’;
$txpcfg[‘txpath’] = ‘/var/www/html/textpattern’;
$txpcfg[‘dbcharset’] = ‘utf8mb4’;
// For more customization options, please consult config-dist.php file.
?>

Even it isn’t working & showing the same error.

How I can get rid over this error? Apache:Apache has given full owner ship of /var/www/html directory.

Thank you for your time to read & respond to my query.

Regards

Moderator PS: Modified the message to hide some information

Last edited by Dragondz (2021-11-30 07:40:00)

Dragondz · 2021-11-30 07:44:34

Hi Aziz

Where do you put config.php file ? it should be in /html/textpattern/ directory.

in the error message it also state that is not finding some file, tha also could be missing some files, can upload again the textpattern file to your server and try again ?

if you have an url that i can check that could help (you can send it by private message)

Here the link to the installation doc : https://docs.textpattern.com/setup/installing-the-software

Cheers.

yawar.aziz · 2021-11-30 08:24:21

Dear Moderator,

Thank you for prompt reply.

Unfortunately, it is LAN IP & cannot be accessed from outside.

But let me tell you my steps I have done so far to make things functional.

1) Downloaded the tar.gz file.
2) Unzip the same with “unzip latest.zip -d /var/www/html” & it became a folder named textpattern-4.8.5 or textpattern-4.8.7.
3) Move the textpattern-4.8.5/textpattern/* to /var/www/html; so that index could be directly accessed through IPv4 without writing x.x.x.x/textpattern/index.
4) Change ownership to apache “chown -R apache:apache /var/www/html”.
5) Through browser, accessed x.x.x.x/setup, selected “English” & on the next page did “config.php” settings as mentioned in my last post. The config.php file is placed at /var/www/html/textpattern/config.php. (Even if I place config.php in /var/www/html & access x.x.x.x, it shows the same error message that “Database connection is successful but the textpattern table was not found).
6) When I regenerate config.php file then it shows DB populate error as shown in my first post.

Now I am confused what I am missing.

The software installation as defined in URL as shown https://docs.textpattern.com/setup/installing-the-software isn’t working & showing the same error.

Help is requested please.

Thank you

Last edited by yawar.aziz (2021-11-30 08:24:41)

Dragondz · 2021-11-30 09:41:57

Hi
When i look at you error :

/var/www/html/vendors/Textpattern/Iterator/RecDirIterator.php

it seems to me that you are not placing files in the right place!

The files index.php and css.php should be on /var/www/html/ and all other textpattern directory should be under there like files images and textpattern like that :
/var/www/html/files/
/var/www/html/images/
/var/www/html/textpattern/
/var/www/html/themes/

And in textpattern directory you should have config.php and vendors and other directories
/var/www/html/textpattern/config.php
/var/www/html/vendors/
/var/www/html/lib/
…

Check please and make another attempt and if there is errors post them again to check and see if there is some new ones.

Cheers.

yawar.aziz · 2021-11-30 09:55:39

Done.

Problem solved.

Thank you very much for your help.

How I can mark this problem as “SOLVED”.

jakob · 2021-11-30 10:07:15

Glad you got it solved. I marked it as [SOLVED] for you.

yawar.aziz · 2021-11-30 10:11:50

Thank You :)

Textpattern CMS

Textpattern CMS support forum

#1 2021-11-29 10:30:00

[SOLVED] Database connection successful, but textpattern table not.

#2 2021-11-29 12:09:54

Re: [SOLVED] Database connection successful, but textpattern table not.

#3 2021-11-30 05:15:36

Re: [SOLVED] Database connection successful, but textpattern table not.

#4 2021-11-30 07:44:34

Re: [SOLVED] Database connection successful, but textpattern table not.

#5 2021-11-30 08:24:21

Re: [SOLVED] Database connection successful, but textpattern table not.

#6 2021-11-30 09:41:57

Re: [SOLVED] Database connection successful, but textpattern table not.

#7 2021-11-30 09:55:39

Re: [SOLVED] Database connection successful, but textpattern table not.

#8 2021-11-30 10:07:15

Re: [SOLVED] Database connection successful, but textpattern table not.

#9 2021-11-30 10:11:50

Re: [SOLVED] Database connection successful, but textpattern table not.

Board footer