How to report installation and operation issues

[pandrei]

3 hours ago, xcmro_875 said:

phpinfo gives following information:

I see, your webserver is apache, but you have no rights to see it in the ps command.

Yet another idea. Try this test:

1. Temporary rename .htaccess to .htaccess_temp in public_html directory

2. Test access to http://osc4.xxxx/catalog/admin/login and to the folders of demoshops

3. Rename back .htaccess_temp to .htaccess

[xcmro_875]

Am 16.8.2022 um 15:31 schrieb pandrei:

Temporary rename .htaccess to .htaccess_temp in public_html directory 

Thank you for your answer, but I have no .htaccess file in the public_html directory

I protected the directory where I installed Oscommerce with a password in htaccess.

I renamed this .htaccess file but I still had no access to the admin and no access to the folders of demoshop.

 

[pandrei]

1 hour ago, xcmro_875 said:

Thank you for your answer, but I have no .htaccess file in the public_html directory

It's hard to say what really happens. Could you send at least url to your server in pm?

[xcmro_875]

Am 18.8.2022 um 20:27 schrieb pandrei:

It's hard to say what really happens. Could you send at least url to your server in pm?

I just sent you the url and access infos in pm

 

[pandrei]

11 hours ago, xcmro_875 said:

I just sent you the url and access infos in pm

Thank you. Tested and replied to you.

[edoscript]

Hello everyone,

I am using osCommerce since 2002-ish. I just downloaded the new 4.04 version and when I try to install, right after providing the MySQL details I get an error message: Error. Can't update database.

Both lib/frontend/runtime/ and lib/backend/runtime/ folders are empty. I checked the server log files and here is what I found:
==
 [06-Sep-2022 04:11:54 UTC] PHP Warning:  mysqli_query(): Empty query in /home/ultragen/public_html/install/install_steps/db_access.class.php on line 224
==

And here is the code causing the issue:

        $sqls = $this->parse_sql_file($restore_from);

        foreach($sqls as $sql) {

            $result = mysqli_query($link, $sql);

            if (!$result) {

                $this->log('install_error', 'Can\'t update database.');

                return false;

            }

 

As far as server details, here it is:

Server OS:

Linux 3.10.0-1160.59.1.el7.x86_64

Database:

MySQL 5.7.39

HTTP Server:	Apache/2.4.54 (cPanel) OpenSSL/1.1.1q mod_bwlimited/1.4 mod_fcgid/2.3.9 Phusion_Passenger/6.0.12
PHP Version:	7.4.30 (Zend: 3.4.0)

 

I would appreciate any feedback.

Thank you in advance.

- Ed 

 

Edited September 6, 2022 by edoscript

[osCommerce-Official]

@pandrei could you please help Ed? Thank you!

[pandrei]

13 hours ago, edoscript said:

                $this->log('install_error', 'Can\'t update database.');

Hello Ed,

Please change this line to

$this->log('install_error', 'Can\'t update database: '. $link->error);

and install again. You will see the detailed error message.

[edoscript]

6 hours ago, pandrei said:

Hello Ed,

Please change this line to

$this->log('install_error', 'Can\'t update database: '. $link->error);

and install again. You will see the detailed error message.

Thanks pandrei, 

I tried it, however it didn't return any error message. Apparently, $link->error returns empty.

Thanks for the idea though.

[pandrei]

45 minutes ago, edoscript said:

I tried it, however it didn't return any error message. Apparently, $link->error returns empty.

It's a bit strange. I have another idea. Try this line:

$this->log('install_error', 'Can\'t update database: ' .  $link->error . 'sql: ' . $sql);

At least we will know which sentence caused the error.

[edoscript]

39 minutes ago, pandrei said:

It's a bit strange. I have another idea. Try this line:

$this->log('install_error', 'Can\'t update database: ' .  $link->error . 'sql: ' . $sql);

At least we will know which sentence caused the error.

I agree it is strange. Actually, I tried the $sql line yesterday and it returned blank. I tried it again now with your line and got the same result: 

Error. Can't update database: sql:

[edoscript]

14 minutes ago, edoscript said:

I agree it is strange. Actually, I tried the $sql line yesterday and it returned blank. I tried it again now with your line and got the same result: 

Error. Can't update database: sql:

I see /sql/trueloaded.sql is empty. Could it have to do anything with it?

I checked the DB name, user and password are all good in the script.

Edited September 7, 2022 by edoscript

[pandrei]

14 minutes ago, edoscript said:

I see /sql/trueloaded.sql is empty. Could it have to do anything with it?

Try the following code:

foreach($sqls as $sql) {
    if (empty(trim($sql))) continue;
    $result = mysqli_query($link, $sql);
    if (!$result) {
         $this->log('install_error', 'Can\'t update database: ' .  $link->error . 'sql: ' . $sql);
         return false;
    }

[edoscript]

26 minutes ago, pandrei said:

Try the following code:

foreach($sqls as $sql) {
    if (empty(trim($sql))) continue;
    $result = mysqli_query($link, $sql);
    if (!$result) {
         $this->log('install_error', 'Can\'t update database: ' .  $link->error . 'sql: ' . $sql);
         return false;
    }

Good. Thanks. I passed that error. I will continue and then we'll see if it creates any issues. Hopefully not.

Thanks again.

[edoscript]

31 minutes ago, edoscript said:

Good. Thanks. I passed that error. I will continue and then we'll see if it creates any issues. Hopefully not.

Thanks again.

On the next page, after I submitted the Settings (General, Contact Information, Address) it appears that the platforms table is missing. I got the following error: Error. Can't update database settings: Table 'ul_store.platforms' doesn't exist 

I could manually add the table, however I don't know the table details, and maybe this is something that would be better if a solution is found rather than manually overwriting it.

Thanks.

[edoscript]

5 minutes ago, edoscript said:

On the next page, after I submitted the Settings (General, Contact Information, Address) it appears that the platforms table is missing. I got the following error: Error. Can't update database settings: Table 'ul_store.platforms' doesn't exist 

I could manually add the table, however I don't know the table details, and maybe this is something that would be better if a solution is found rather than manually overwriting it.

Thanks.

P.S. The other option would be, I can reinstall everything from scratch to make sure nothing went wrong during the initial install. 

[pandrei]

10 hours ago, edoscript said:

P.S. The other option would be, I can reinstall everything from scratch to make sure nothing went wrong during the initial install. 

It's a good idea.

[edoscript]

On 9/8/2022 at 12:12 AM, pandrei said:

It's a good idea.

I did a new installation from scratch and got same issues. I got the same Error. Can't update database. error. Then I followed pandrei's recommendation (thanks) and added

if (empty(trim($sql))) continue;

moved to the next SETTINGS page and got the same Error. Can't update database settings. error.

So I am wondering if this is happening only to me or if there is an issue with the install package.

Thanks in advance.

P.S. I have my original v2.3.4 version with all my added mods and customizations including wholesale ordering and much more (my "Frankenstein" version). However, I want to move forward with the new v4.

[pandrei]

On 9/10/2022 at 8:54 PM, edoscript said:

moved to the next SETTINGS page and got the same Error. Can't update database settings. error.

Could you add one more piece to your "Frankenstein" version? 😊

Open install\install_steps\inst_settings.class.php and change 268 line to:

$this->log('install_error', 'Can\'t update database settings: ' . $link->error);

When you reinstall, you will get the detailed error.

[spidometrs]

Greetings!
I downloaded the archive of OSC_4_06_51797.Zip here https://www.oscommerce.com/download-oscommerce
I have an Inginx server and 10.3.17-mariadb.
OSC V4 cannot install.
The Mariadb base writes, there are no errors when installing.
Configuration files do not record.
The administrative part of the site does not open, gives an error 404.
Catalogs do not open, gives an error 404.
The main page of the site opens normally.

What am I doing wrong?

[Ivan Holbi]

4 hours ago, spidometrs said:

Greetings!
I downloaded the archive of OSC_4_06_51797.Zip here https://www.oscommerce.com/download-oscommerce
I have an Inginx server and 10.3.17-mariadb.
OSC V4 cannot install.
The Mariadb base writes, there are no errors when installing.
Configuration files do not record.
The administrative part of the site does not open, gives an error 404.
Catalogs do not open, gives an error 404.
The main page of the site opens normally.

What am I doing wrong?

Hi Sergey,

Please check your server further according to the following articles.

https://wiki.oscommerce.com/index.php?title=Installing_osCommerce_4_on_Dedicated_Server,_Cloud_Server_or_VPS

https://wiki.oscommerce.com/index.php?title=Installing_osCommerce_v.4.0

Also the thing is that we do not support the servers with the web-service inginx.

Best regards,

Ivan

[spidometrs]

4 hours ago, Ivan Holbi said:

https://wiki.oscommerce.com/index.php?title=Installing_osCommerce_v.4.0

Quote

osCommerce 4 also supports Nginx 1.x with additional configuration.

What additional configuration nginx 1.x needs to be done?

[jimdanforth]

Having very consistent error in category creation and use.

if I create the following:

top category

-category 1
--sub cat a
--Sub Cat b
--sub Cat C

-category 2
-sub cat a
--sub cat b
--sub cat c

 

and then from front end select say category 1, then sub a..... it will switch to category 2 sub a if the names are the same.

 

[jimdanforth]

Good thing replies are prompt from the support team.

[osCommerce-Official]

On 10/10/2022 at 10:50 PM, jimdanforth said:

Having very consistent error in category creation and use.

if I create the following:

top category

-category 1
--sub cat a
--Sub Cat b
--sub Cat C

-category 2
-sub cat a
--sub cat b
--sub cat c

 

and then from front end select say category 1, then sub a..... it will switch to category 2 sub a if the names are the same.

 

@Ivan Holbicould you please comment on this issue?