Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

osCommerce-Official

How to report installation and operation issues

Recommended Posts

3 hours ago, xcmro_875 said:

phpinfo gives following information:

image.thumb.png.7409d7a7dd9f603db72b3201c9fe0388.png

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

Share this post


Link to post
Share on other sites
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.

 

Share this post


Link to post
Share on other sites
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?

Share this post


Link to post
Share on other sites
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

 

Share this post


Link to post
Share on other sites
11 hours ago, xcmro_875 said:

I just sent you the url and access infos in pm

Thank you. Tested and replied to you.

Share this post


Link to post
Share on other sites

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 by edoscript

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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:

Share this post


Link to post
Share on other sites
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 by edoscript

Share this post


Link to post
Share on other sites
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;
    }

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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. 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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?


No outside url's in signatures allowed - thanks

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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.

 

Share this post


Link to post
Share on other sites
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? 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×