This topic contains a post which is marked as Best Answer. Press here if you would like to see it.
*

pipetko

  • ****
  • 112 posts
Hello, I have an old osclass, that is little messed up after "upgrading" with the many developer versions. I tried to upgrade with this one, bu the whole website died and messed up even more.
So now I want to make clean install with the OsclassPoint version of osclass, but here is a problem. I dont have huge number of ads or users, but still is a problem.

Is there a way to backup all users and ads and later import them easily ?
« Last Edit: December 22, 2020, 08:05:39 PM by pipetko »

*

MB Themes

Re: I need to make a fresh install, how to export all ads and users ?
« Reply #1 on: December 23, 2020, 02:25:04 PM »
@pipetko
This can be time consuming task. First I would try:
- remove all files except oc-content folder and config.php
- download osclass and extract it in your installation folder
- go to oc-admin and check if you are prompted for upgrade

Alternative is:
- download oc-content/uploads folder
- export all data from sql tables (you need all of them), do export in way you can simply import data only (tables will be created by osclass)
- install osclass
- import uploads folder you've downloaded
- import data into your data tables
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

Andrey

  • ****
  • 157 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #2 on: December 23, 2020, 05:26:26 PM »
- remove all files except oc-content folder and config.php
- download osclass and extract it in your installation folder
- go to oc-admin and check if you are prompted for upgrade

Yes, in this way I switched from version 3.8 to 4.1 and then updated like everyone else.
But I would also like to transfer users and ads to a clean database.

Ad Importer Osclass plugin can't export users and ads to xml?

*

MB Themes

Re: I need to make a fresh install, how to export all ads and users ?
« Reply #3 on: December 23, 2020, 06:03:02 PM »
@Andrey
No it works with listings only.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #4 on: December 28, 2020, 11:03:21 PM »
@pipetko
This can be time consuming task. First I would try:
- remove all files except oc-content folder and config.php
- download osclass and extract it in your installation folder
- go to oc-admin and check if you are prompted for upgrade
I will try this one.

Alternative is:
- download oc-content/uploads folder
- export all data from sql tables (you need all of them), do export in way you can simply import data only (tables will be created by osclass)
- install osclass
- import uploads folder you've downloaded
- import data into your data tables
I know about this one, but in this way if there is some mess up in the db it wont be fixed.

It is sad, there should be a way to export:
users, listings ( with files for the ads ), cathegories, theme settings, website settings ( as language website name, friendly url's data ). SEO data export of the SEO plugin will be a good thing too because it is important as well.

Most important is exporting of categories, users and listings.
Pfff :(

Thanks for all advices.

P.S. I am using the new version of a fresh new instaltion ( client order ). For now is working ok, except that uploading new Language is giving 500 error for some reason. I can upload plugins, themes no prob, only with lang is 500 error. I will create another topic for this one.
« Last Edit: December 28, 2020, 11:06:09 PM by pipetko »

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #5 on: January 20, 2021, 04:10:13 PM »
today tried updating... no results - oc-admin/index.php?page=upgrade is giving 500 error and thats it

I removed all old files ( except like you suggested config.php and content folder

In error log:
[20-Jan-2021 14:49:01 UTC] PHP Warning:  require_once(/oc-includes/osclass/default-constants.php): failed to open stream: No such file or directory in oc-load.php on line 45
[20-Jan-2021 14:49:01 UTC] PHP Fatal error:  require_once(): Failed opening required '/oc-includes/osclass/default-constants.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /oc-load.php on line 45
[20-Jan-2021 14:49:49 UTC] PHP Warning:  require_once(/oc-includes/osclass/default-constants.php): failed to open stream: No such file or directory in /oc-load.php on line 45
[20-Jan-2021 14:49:49 UTC] PHP Fatal error:  require_once(): Failed opening required '/oc-includes/osclass/default-constants.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /oc-load.php on line 45
[20-Jan-2021 14:50:03 UTC] PHP Warning:  require_once(/oc-includes/osclass/default-constants.php): failed to open stream: No such file or directory in /oc-load.php on line 45
[20-Jan-2021 14:50:03 UTC] PHP Fatal error:  require_once(): Failed opening required '/oc-includes/osclass/default-constants.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /oc-load.php on line 45
[20-Jan-2021 14:50:07 UTC] PHP Warning:  require_once(/oc-includes/osclass/default-constants.php): failed to open stream: No such file or directory in /oc-load.php on line 45
[20-Jan-2021 14:50:07 UTC] PHP Fatal error:  require_once(): Failed opening required '/oc-includes/osclass/default-constants.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /oc-load.php on line 45
[20-Jan-2021 14:50:41 UTC] PHP Warning:  require_once(/oc-includes/vendor/composer/autoload_real.php): failed to open stream: No such file or directory in /oc-includes/vendor/autoload.php on line 5
[20-Jan-2021 14:50:41 UTC] PHP Fatal error:  require_once(): Failed opening required '/oc-includes/vendor/composer/autoload_real.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /oc-includes/vendor/autoload.php on line 5
« Last Edit: January 20, 2021, 04:31:19 PM by pipetko »

*

MB Themes

Re: I need to make a fresh install, how to export all ads and users ?
« Reply #6 on: January 20, 2021, 04:30:49 PM »
It seems you are missing numerous files.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #7 on: January 20, 2021, 05:35:14 PM »
It seems you are missing numerous files.
With the same archive I have already made 3 cleint websites. It is your version. I have reuploaded all files.. Same problem

*

MB Themes

Re: I need to make a fresh install, how to export all ads and users ?
« Reply #8 on: January 20, 2021, 05:58:09 PM »
PHP Warning:  require_once(/oc-includes/osclass/default-constants.php): failed to open stream: No such file or directory in oc-load.php on line 45

Default constants file exists in zip, not on your site.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #9 on: January 21, 2021, 09:40:53 AM »
PHP Warning:  require_once(/oc-includes/osclass/default-constants.php): failed to open stream: No such file or directory in oc-load.php on line 45

Default constants file exists in zip, not on your site.
It dissapeared after downloading again from yout osclass website the osclass 4.2.2 and uploading. It turns out probably for some reason after moving the file it was corrupted ( I am with ssd on my computer ). Anyway it still gets the 500 error. The error log now is empty, nothing new there.. Thried the second option with the database.. As I expected it does not work at all. Tried new instalation and few other ways to implement the db.. no result and thats all.. it is impossible to upgrade to your version. I noticed different things in the db. I guess the EVO version is with a bit different structure than the original osclass.

You have to make payd plugin to export users, ads and cathegories... This will be for shure helpfull to a lot of people.

P.S. I have to say that to usual way of upgrade does not stop the front end of the website to work. Users CAN log in and post ads... But the admin is blocked from the Upgrade page. I can log in and after login it redirects me to the upgrade page forever and the upgrade page is with the 500 error
« Last Edit: January 21, 2021, 09:43:25 AM by pipetko »

*

MB Themes

Re: I need to make a fresh install, how to export all ads and users ?
« Reply #10 on: January 21, 2021, 12:16:14 PM »
@pipetko
Enable error log and check what is behind that error 500.
You should have removed also old files those are going to be replaced.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #11 on: January 21, 2021, 01:07:40 PM »
I did that. Error log is empty

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #12 on: April 25, 2021, 10:44:08 AM »
since there is no absolutely no normal way to export neither users or ads or whatever..

What I did is:
Installing new OC with osclasspoint version

imported the db with all from my old website

I deleted users and item ables
Renamed from the old db to the new db's prefix and deleted the tables I didnt needed/used from the old db
I havent tested yet is the user registration working or not.
It is cynd of working - ads and users are there, but I am facing problems:

I cant post ads neither as user or admin - It says the ad is published successefuly, but the ad is gone. there is no ad.. Also when try to edit ad I it does not save it, actually it Gives me an error "Array" and thats it.

Owh YEs and another thing.
weirdly now front ( public ) is all in english. I have themes translation on the language, it is there, but it is showing the website only in English...... There is no info for that but I guess you put now the translations within OC for all the themes ?!
I am not interested in translation in the admin part, only the public part. But I can make a translation, I need the files and info where ot put it after that.

EdIT:
I have tested, unfortunately user registration both from admin and front end is not working as well :(

ERROR LOG:
download link: https://dox.abv.bg/download?id=27791ea0ad#
« Last Edit: April 25, 2021, 11:26:13 AM by pipetko »

*

MB Themes

Re: I need to make a fresh install, how to export all ads and users ?
« Reply #13 on: April 25, 2021, 12:52:35 PM »
This error message indicates there is wrong table structure.
25-Apr-2021 12:09:03 Europe/Sofia] PHP Notice:  Undefined index: i_login_fails in /home/public_html/oc-includes/osclass/controller/login.php on line 74

I am really not sure why you did not try just do clean installation and then export content of tables one by one.
Removing original table and replacing it with new, without checking structure does not make sense
« Last Edit: April 25, 2021, 12:55:21 PM by MB Themes »
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

pipetko

  • ****
  • 112 posts
Re: I need to make a fresh install, how to export all ads and users ?
« Reply #14 on: April 25, 2021, 01:47:57 PM »
This error message indicates there is wrong table structure.
25-Apr-2021 12:09:03 Europe/Sofia] PHP Notice:  Undefined index: i_login_fails in /home/public_html/oc-includes/osclass/controller/login.php on line 74

I am really not sure why you did not try just do clean installation and then export content of tables one by one.
Removing original table and replacing it with new, without checking structure does not make sense
Simple. I am not dev and just trying to do something I dont understant that good. So I am doing it the way i think it is. And since no one is giving any specific instructions.... That is how i do it.... We disqus this question from more than a
 half a year already... If i knew how to do it I wont ask or say anything here ;)
In older messages in this topic I understand that was the way i shoud do it... didnt understand that I should export each roll the data only one by one.

P.S. This with the login looks weird.. I replaced only items and existing users tables, nothing else. The user can login, but posting ads and registering new user is not working only.
« Last Edit: April 25, 2021, 01:52:15 PM by pipetko »