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);

Your url looks weird:
ssl://smadirectory.com:443

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.

@pixelpadre2
Will check recaptcha issue asap.

recaptcha (new Item) works in Bender but throws an error in Sigma.

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?

@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.

table structure different between 3.9 and 4.01?

Yes

Is importing old data into new table structure possible?  I suspect the answer is no.

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.

Are we supposed to know which tables are different?  This is a lot of work to expect from users.

@pixelpadre2
No, proper update will handle all the changes.
https://osclass.osclasspoint.com/installation

@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.?

@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.