Osclass Support Forums

General osclass questions => General discussion => Topic started by: pixelpadre2 on October 12, 2020, 12:46:30 AM

Title: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 12:46:30 AM
I cant add any listings.  Debug says


Warning: fsockopen(): SSL operation failed with code 1. OpenSSL Error messages: error:1408F10B:SSL routines:ssl3_get_record:wrong version number in /home/scanmyid/public_html/smadirectory.com/oc-includes/osclass/utils.php on line 333

Warning: fsockopen(): Failed to enable crypto in /home/scanmyid/public_html/smadirectory.com/oc-includes/osclass/utils.php on line 333

Warning: fsockopen(): unable to connect to ssl://smadirectory.com:443 (Unknown error) in /home/scanmyid/public_html/smadirectory.com/oc-includes/osclass/utils.php on line 333

Heres line 333

 $fp = fsockopen($host, $port);

        if ($fp === false) {
            return false;
        }
        $data              = http_build_query($_data);
        $out               = 'POST ' . $path . ' HTTP/1.1' . PHP_EOL;
        $out               .= 'Host: ' . $url['host'] . PHP_EOL;
        $out               .= 'Referer: Osclass ' . osc_version() . PHP_EOL;
        $out               .= 'Content-type: application/x-www-form-urlencoded' . PHP_EOL;
        $out               .= 'Content-Length: ' . strlen($data) . PHP_EOL;
        $out               .= 'Connection: close' . PHP_EOL . PHP_EOL;
        $out               .= $data;
        $number_bytes_sent = fwrite($fp, $out);
        fclose($fp);
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 06:49:18 AM
Your url looks weird:
ssl://smadirectory.com:443
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 12:29:31 PM
I think I fixed the ssl problem.   dns showed ip6 when my server is only dishing out ip4.

New problem though when I post in sigma I get error message.

The Recaptcha code is wrong.

When I post in bender, it says listing is published.  Weird because the number of listings increases by one but the listing does not appear.
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 01:10:22 PM
@pixelpadre2
Will check recaptcha issue asap.
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 02:04:32 PM
recaptcha (new Item) works in Bender but throws an error in Sigma.
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 02:34:56 PM
I think I fixed the ssl problem.   dns showed ip6 when my server is only dishing out ip4.

New problem though when I post in sigma I get error message.

The Recaptcha code is wrong.

When I post in bender, it says listing is published.  Weird because the number of listings increases by one but the listing does not appear.

This is weird.

The new listing in bender will not appear, but admin email shows a new listing with URL

Url: https://smadirectory.com//_i   <--whats that all about?
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 04:16:03 PM
@pixelpadre2
That would probably mean that item has been created in t_item table, but reference tables has not been filled with other information.
Make sure your table structure is correct and match to latest osclass table structure.
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 04:44:21 PM
table structure different between 3.9 and 4.01?
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 05:10:32 PM
Yes
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 05:18:29 PM
Is importing old data into new table structure possible?  I suspect the answer is no.
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 05:55:22 PM
It is possible, as all new fields are nullable so not importing data for new columns will not throw error.
However, columns must be defined is insert statement.
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 07:51:52 PM
Are we supposed to know which tables are different?  This is a lot of work to expect from users.
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 08:25:32 PM
@pixelpadre2
No, proper update will handle all the changes.
https://osclass.osclasspoint.com/installation
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 12, 2020, 09:26:19 PM
@pixelpadre2
No, proper update will handle all the changes.
https://osclass.osclasspoint.com/installation

Im not trying to be difficult here, but that link makes absolutely no sense.  First, the image is for upgrading from 3.8.  Secondly, going thru the install is going to install a fresh database if I understand correctly.  Then it says to over write what you just over wrote. and the database will magically be the way it should.  Its total nonsense, and is of no use to anyone who has a current lesser version with a database that does not conform with version 4.0? 4.01? 4.1?

I am staying with 3.9 until you figure out how to make this a seamless integration with a whole lot of documentation.   

What good are all of the improvements if you cant even upgrade.?
Title: Re: Add listing admin panel
Post by: MB Themes on October 12, 2020, 09:39:24 PM
@pixelpadre2
No matter what version do you have now, upgrade process is same.
https://osclass.osclasspoint.com/installation

- upload osclass ZIP file into your root directory where osclass is installed
- extract ZIP to replace old files
- go to oc-admin, you will be prompted to perform upgrade
- click on "Upgrade now" button
- once finish, everything is updated and ready to use
- Make sure to backup your files and database before each upgrade! In case you got stucked on upgrade, restore your database and file system.

That looks so easy, if you read it.
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 13, 2020, 01:38:14 AM
crucial point you have missed.

The new files will have config-sample.php.  Which file should be used?  sample or real.?

You have to be explicit, I mean really explicit.  Just because you know what your are thinking doesnt mean everyone else knows what you are thinking.
Title: Re: Add listing admin panel
Post by: MB Themes on October 13, 2020, 08:16:31 AM
@pixelpadre2
config-sample.php is backup file in case config.php would be removed or corrupted.
Using this file as backup has been retaken from wordpress approximatelly 9 years ago.
Title: Re: Add listing admin panel
Post by: pixelpadre2 on October 14, 2020, 04:04:41 PM
The reason I ask is because if sample is used, the install process assumes new install and real assumes database update, at least that is the process in zencart.
Title: Re: Add listing admin panel
Post by: MB Themes on October 14, 2020, 04:06:24 PM
@pixelpadre2
config-sample.php is not used anywhere in the script.