Support Forums - Classified Ads Script Osclass

General osclass questions => General discussion => Topic started by: MB Themes on November 04, 2021, 03:13:12 PM

Title: New major version of Osclass released - v8
Post by: MB Themes on November 04, 2021, 03:13:12 PM
Hey everyone,
Osclass 8.0 has been released today and is next milestone to create best classifieds script.
There are several very important topics, make sure to read them ;)

Changelog: https://osclass-classifieds.com/changelog
Read about changes on blog: https://osclasspoint.com/blog/osclass-v8-release-continuous-development-setup-b37

Title: Re: New major version of Osclass released
Post by: MB Themes on November 04, 2021, 03:25:16 PM
Please beware that during upgrade you may get fake warnings from database.

 ???
Title: Re: New major version of Osclass released
Post by: Nagy Csaba on November 04, 2021, 08:59:04 PM
Hi.
this is what i get when i upgrade afret thid error 500 in admin page, tried thid 3 times and the same
upgrading from 4.4.0

Upgrade
Upgrading your Osclass installation (this could take a while):
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_2
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_4
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_6
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_8
ALTER TABLE oc_t_item_location DROP FOREIGN KEY oc_t_item_location_ibfk_9
ALTER TABLE oc_t_item_meta DROP FOREIGN KEY oc_t_item_meta_ibfk_3
ALTER TABLE oc_t_item_meta DROP FOREIGN KEY oc_t_item_meta_ibfk_4
ALTER TABLE oc_t_item_resource DROP FOREIGN KEY oc_t_item_resource_ibfk_2
ALTER TABLE oc_t_item_stats DROP FOREIGN KEY oc_t_item_stats_ibfk_2
Osclass has some errors
We've encountered some problems while updating the database structure. The following queries failed:

ALTER TABLE oc_t_preference ADD UNIQUE KEY (s_section, s_name)
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 04, 2021, 09:08:33 PM
Those look like ghost errors as these updates osclass performs because of change in struct.sql.
Have you tried manual upgrade? You may PM me ftp login and will check it in detail.
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 04, 2021, 10:07:17 PM
@Nagy
I've took a detail look on what is going on behind hood and problem should be resolved by adding this line:
Code: [Select]
define('AUTO_UPGRADE', true);       

above this line:
Code: [Select]
require(LIB_PATH.'osclass/upgrade-funcs.php');
in file:
Code: [Select]
oc-admin/upgrade.php
It looks like for some reason, installer/struct.sql may be on upgrade compared against current database structure - but as you see it may bring errors like by attempts to remove some foreign keys or changing field types.
As far as I know, these changes are done manually in upgrade-func.php and this part of code (upgrade-func.php line 15-35) seems to me like obsolete part of upgrade process.

Test and let me know ;)
Title: Re: New major version of Osclass released - v8
Post by: oneloveb on November 04, 2021, 10:44:55 PM
I want to  backup before I upgrade, but I get an error 500 when I clicked backup in oc-admin
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 05, 2021, 07:06:24 AM
@oneloveb
Please create own thread, as you are doing backup before upgrade on previous version.
Also consider using hosting backup features if available.
Title: Why does version 8 still stand for upgrades (at the top)
Post by: slaven on November 05, 2021, 01:41:02 PM
Why does version 8 still stand for upgrades (at the top) even though we've already done upgrades to 8.0.0?
Tnx!
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 05, 2021, 02:23:56 PM
@alexborg
It looks like update cache was not cleaned. I suppose if you go to settings > general and check for new updates, this will disappear.
Title: Re: New major version of Osclass released - v8
Post by: slaven on November 05, 2021, 02:39:44 PM
It doesn't work ... it's possible that an error occurred during the "upgrade".

How can I manually clear that cache regarding the upgrade?
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 05, 2021, 03:22:10 PM
@alexborg
Check this in your database:
Code: [Select]
SELECT * FROM `oc_t_preference` where s_section = 'osclass' and s_name = 'version';
s_value should be 800

Then check in database:
Code: [Select]
SELECT * FROM `oc_t_preference` where s_section = 'osclass' and s_name ='update_core_json';
s_value should be empty string
Title: Re: New major version of Osclass released - v8
Post by: MvdO79 on November 05, 2021, 04:17:22 PM
Awesome updates, thanks for all the work!  :D
Title: Re: New major version of Osclass released - v8
Post by: slaven on November 05, 2021, 05:11:23 PM
:)  We will need a php / mysql expert to upgrade Osclass
very funny.

Problem solved ... thanks!
Title: Re: New major version of Osclass released - v8
Post by: MvdO79 on November 05, 2021, 06:49:23 PM
:)  We will need a php / mysql expert to upgrade Osclass
very funny.

Problem solved ... thanks!

Using the tips from reply #4 for me the upgrade went well indeed  :)  8)
Title: Re: New major version of Osclass released - v8
Post by: mwindey on November 05, 2021, 06:59:23 PM
Updated without issues here.... clicked update in admin panel and installed update in 1 minute :-) Thanks MB Themes thumbs up :)
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 05, 2021, 07:03:06 PM
I have more than 10 installations, some of them wihout any hassle, some were reporting false-positive errors but was able to get it done in all of them in few minutes  8)

Anyway, ready for improvements and anyone that is having issues, feel free to provide details. There is no software without bugs  :-*
Title: Re: New major version of Osclass released - v8
Post by: Vlad7 on November 05, 2021, 09:33:09 PM
What is the best encoding to choose in MySQL. utf8mb4_0900_ai_ci standard?
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 05, 2021, 09:37:04 PM
That one should support emoji, but standard is utf8_ci if I remember correctly
Title: Re: New major version of Osclass released - v8
Post by: Vlad7 on November 06, 2021, 09:49:19 PM
I am using osclass 4.4. I got an error in my error_log file! Is this related to the release of a new version of osclass 8.0.0?

[05-Nov-2021 11:30:03 Europe/Kiev] PHP Fatal error:  Uncaught Error: Object of class stdClass could not be converted to string in /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php:1037
Stack trace:
#0 /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php(1037): implode(', ', Array)
#1 /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php(1017): DBCommandClass->_replace('oc_t_preference', Array, Array)
#2 /home2/ukagroco/public_html/oc-includes/osclass/model/Preference.php(210): DBCommandClass->replace('oc_t_preference', Array)
#3 /home2/ukagroco/public_html/oc-includes/osclass/helpers/hPreference.php(1289): Preference->replace('update_core_jso...', Object(stdClass), 'osclass', 'STRING')
#4 /home2/ukagroco/public_html/oc-includes/osclass/utils.php(2528): osc_set_preference('update_core_jso...', Object(stdClass))
#5 /home2/ukagroco/public_html/oc-includes/osclass/cron.php(85): osc_do_auto_upgrade()
#6 /home2/ukagroco/public_html/index.php(76): require_once('/home2/ukagro in /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php on line 1037
[06-Nov-2021 11:30:02 Europe/Kiev] PHP Fatal error:  Uncaught Error: Object of class stdClass could not be converted to string in /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php:1037
Stack trace:
#0 /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php(1037): implode(', ', Array)
#1 /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php(1017): DBCommandClass->_replace('oc_t_preference', Array, Array)
#2 /home2/ukagroco/public_html/oc-includes/osclass/model/Preference.php(210): DBCommandClass->replace('oc_t_preference', Array)
#3 /home2/ukagroco/public_html/oc-includes/osclass/helpers/hPreference.php(1289): Preference->replace('update_core_jso...', Object(stdClass), 'osclass', 'STRING')
#4 /home2/ukagroco/public_html/oc-includes/osclass/utils.php(2528): osc_set_preference('update_core_jso...', Object(stdClass))
#5 /home2/ukagroco/public_html/oc-includes/osclass/cron.php(85): osc_do_auto_upgrade()
#6 /home2/ukagroco/public_html/index.php(76): require_once('/home2/ukagro in /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php on line 1037
Title: Re: New major version of Osclass released - v8
Post by: bgd on November 07, 2021, 09:20:22 AM
Thank you for your work.

I have no problems.
Title: Re: New major version of Osclass released - v8
Post by: Vlad7 on November 07, 2021, 09:59:16 AM
With a new installation, I receive an HTTP ERROR 500 from the server
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 07, 2021, 11:26:44 AM
I recommend to create new thread for each problem as it is not possible to track multiple issues at same time
Title: Re: New major version of Osclass released - v8
Post by: tomi327 on November 07, 2021, 09:44:42 PM
Upgraded from admin. Without problem. Thank you osclasspoint.  :)

MySQL version: 5.5.5-10.5.9-MariaDB
PHP version: 7.4.16
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 08, 2021, 10:27:11 AM
Upgraded from admin. Without problem. Thank you osclasspoint.  :)

MySQL version: 5.5.5-10.5.9-MariaDB
PHP version: 7.4.16
Glad to hear that  :-*

With a new installation, I receive an HTTP ERROR 500 from the server
Enable error logging and provide details of errors you got so we can investigate it.

I am using osclass 4.4. I got an error in my error_log file! Is this related to the release of a new version of osclass 8.0.0?

[05-Nov-2021 11:30:03 Europe/Kiev] PHP Fatal error:  Uncaught Error: Object of class stdClass could not be converted to string in /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php:1037
Stack trace:
#0 /home2/ukagroco/public_html/oc-includes/osclass/classes/database/DBCommandClass.php(1037): implode(', ', Array)
...
Error probably from Osclass 4.1, being fixed in 8.0.1

Thank you for your work.
I have no problems.
Cool  8)
Title: Re: New major version of Osclass released - v8
Post by: Marius on November 11, 2021, 06:29:45 PM
something serious?
[11-Nov-2021 12:00:33 Europe/Bucharest] PHP Warning:  fsockopen(): unable to connect to ssl://pgn.ro:443 (No route to host) in /home/pgnro/public_html/oc-includes/osclass/utils.php on line 344
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on November 11, 2021, 06:56:22 PM
@Marius
Not related to update, but never seen such error. Maybe check with hosting what it actually means.
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 09, 2022, 06:36:20 AM
Hi ,

Thanks for Your Help

I have little issue . There is an option in website "Report Listing" for Product.

But this option is enable for all user. Whenever anyone click on Report listing I want to show an alert that you must login first ..

 or It is possible to show Report listing option only for login User.

If possible please tell me the solution.. because i am getting many fake report listing error.

also if possible that which user report then please tell me that ..

Thanks.. :-)
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on March 09, 2022, 07:21:37 AM
Currently it is possible just if you do that on theme level.
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 09, 2022, 07:51:48 AM
Currently it is possible just if you do that on theme level.

But How??
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on March 09, 2022, 08:01:07 AM
If else osc_is_web_user_logged_in() ...
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 09, 2022, 08:07:03 AM
If else osc_is_web_user_logged_in() ...

Thanks for reply .. I have checked in item.php there is report listing..
but where i have to write this code  - here is code

<div id="report" class="noselect">
          <a href="#" onclick="return false;">
            <i class="fas fa-exclamation-circle"></i>
            <?php _e('Report listing', 'delta'); ?>
          </a>

          <div class="cont-wrap">
            <div class="cont">
              <a id="item_spam" class="reports" href="<?php echo osc_item_link_spam() ; ?>" rel="nofollow"><?php _e('Spam', 'delta') ; ?></a>
              <a id="item_bad_category" class="reports" href="<?php echo osc_item_link_bad_category() ; ?>" rel="nofollow"><?php _e('Misclassified', 'delta') ; ?></a>
              <a id="item_repeated" class="reports" href="<?php echo osc_item_link_repeated() ; ?>" rel="nofollow"><?php _e('Duplicated', 'delta') ; ?></a>
              <a id="item_expired" class="reports" href="<?php echo osc_item_link_expired() ; ?>" rel="nofollow"><?php _e('Expired', 'delta') ; ?></a>
              <a id="item_offensive" class="reports" href="<?php echo osc_item_link_offensive() ; ?>" rel="nofollow"><?php _e('Offensive', 'delta') ; ?></a>
            </div>
          </div>
        </div>
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on March 09, 2022, 08:22:07 AM
@Sanjay
Something like.
Code: [Select]
<div id="report" class="noselect">
  <a href="#" onclick="return false;">
    <i class="fas fa-exclamation-circle"></i>
    <?php _e('Report listing''delta'); ?>
  </a>

  <div class="cont-wrap">
    <div class="cont">
      <?php if(!osc_is_web_user_logged_in()) { ?>
        <em><?php _e('You must be logged in to report listing''delta'); ?></em>
      <?php } else { ?>
        <a id="item_spam" class="reports" href="<?php echo osc_item_link_spam() ; ?>" rel="nofollow"><?php _e('Spam''delta') ; ?></a>
        <a id="item_bad_category" class="reports" href="<?php echo osc_item_link_bad_category() ; ?>" rel="nofollow"><?php _e('Misclassified''delta') ; ?></a>
        <a id="item_repeated" class="reports" href="<?php echo osc_item_link_repeated() ; ?>" rel="nofollow"><?php _e('Duplicated''delta') ; ?></a>
        <a id="item_expired" class="reports" href="<?php echo osc_item_link_expired() ; ?>" rel="nofollow"><?php _e('Expired''delta') ; ?></a>
        <a id="item_offensive" class="reports" href="<?php echo osc_item_link_offensive() ; ?>" rel="nofollow"><?php _e('Offensive''delta') ; ?></a>
      <?php ?>
    </div>
  </div>
</div>
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 09, 2022, 08:49:23 AM
Thanks for your help. Its working ..  :) :) :)
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 09, 2022, 09:18:38 AM
One more thing can i know who report the product?
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on March 09, 2022, 10:01:42 AM
Sorry did not get your question
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 10, 2022, 08:18:12 AM
means - If any user visit any product and click on "Report Listing" for spam or duplicate or ... . So can i know the user details that who is reporting information about product ..

As Person "A" has a Product "X" and Person "B"  (registered user) click on Report Listing -Spam . Then can i know Person "B" is reporting for that Product "X"



Thanks
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on March 10, 2022, 03:14:24 PM
Osclass does not store reported contact details.
I think it is not needed at all.
Title: Re: New major version of Osclass released - v8
Post by: Sanjay Srivastava on March 11, 2022, 05:33:36 AM
Ok.. and many thanks for your Previous Help..
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on March 11, 2022, 07:28:48 AM
@Sanjay
Welcome ;)
Title: Re: New major version of Osclass released - v8
Post by: Lopetoms on May 12, 2022, 07:11:50 PM
hello i need help now intalled OSCLASS 8.0.2 and when change name CATEGORY no is SAVED why?
Title: Re: New major version of Osclass released - v8
Post by: MB Themes on May 12, 2022, 07:31:01 PM
Please create own topic, there is no reason to post such questions into anouncement topic.
Also you have not added any details, error log, query log, steps for reproduction, php version, db version...