after updating to v3434 pos is not working again

0

I updated from v3.2.2 to v3.4.3.4 and followed all the processes, everything seemed well until i login into the dashboard and tried using the POS, it doesn't work. It gives HTTP ERROR 500. i tried everything i can but it wont work.
So i deleted the old installation from and files from Cpanel , created new database from phpmyadmin and install a fresh setup of the SMA-POS V3.4.3.4. I replaced the assets and files folder from my backup of the old working installation. I then imported and replaced index.php, app/config/config.php from backup.
The app works alright and i can access all sales files together with stock items and everything after login. However the POS is still not working. I also cannot view sales or pos invoices by just clicking on it... nothing happens when i do that... check attachment for screenshots.
This is a live working shop and i need to get this resolve as soon as possible.
Kindly reach out. Counting on your help soonest

Question Resolved For: Stock Manager Advance with Point of Sale Module 0 Votes 9 Answers 1.8k Views
Asked by Bryan Richardson 5 years ago

0

Answered by Mian Saleem 5 years ago

Hello,

Please check your server error logs and let me know the error details so that I can suggest.

You can enable app logs by changing the log_threshold to 1 in app/config/config.php and visit the page again. Lastly check the latest log in the app/logs/ folder.

Thank you

0

Answered by Bryan Richardson 5 years ago

Hello,
Thanks for the response.
Kindly find attached the log file from the app log .

0

Answered by Mian Saleem 5 years ago

Hello,

Please tell me about the step no 8? Did you imported all the sql files 3.2.5+?

I have seen db error for missing hide_pos that was in v3.4.12

I have seen composer loading error too. Please check the composer_autoload in app/config/config.php It needs to be

$config['composer_autoload'] = FCPATH.'vendor/autoload.php';

and the last lines of the same files

spl_autoload_extensions('.php');
spl_autoload_register(function ($class) {
    if (substr($class, 0, 3) !== 'CI_') {
        if (file_exists($file = APPPATH . 'core/' . $class . '.php')) {
            require($file);
        }
    }
});

0

Answered by Bryan Richardson 5 years ago

i have corrected the codes and all the other issues have been resolved except the pos. it still not working even after importing the sql files. there was one thing of notice though, check it in the attachment. when i uploaded one of the sql file, it says hide_pos.
i have attached the log files too for your observation. Am thinking if i should import the old sql files from version 3.0+ into the database as well.

0

Answered by Mian Saleem 5 years ago

Can you try to disable strict mode then try again. OR just add new filed name hide_pos type tinyint with default to 0 for sma_products table.

You didn't tell me clear about step 8, It says that you need to import all the sql file one by one starting from 3.2.3 If there are db change that version won't have the sql file so you can import next available.

Thank you

0

Answered by Bryan Richardson 5 years ago

Hello, At step 8, i imported all the sql files into the database. However, i observed that from 3_2_2.sql, the next available file was 3.2.5.sql which i have imported to the database. Also from POS_3_2_2.sql the next available file is POS.3.4.12.sql. So is is possible some of the sql files are not in my db_updates folder. Can you send it to me via my email? i have also edited the hide_pos with tinyint... and uploaded it to phpMyadmin successfully but it would not work. please check attached files and advise if i have done the right thing

0

Answered by Mian Saleem 5 years ago

No. All the file are there. Did you try to add hide_pos file as mentioned in my previous reply. Please add field and then test again.

0

Answered by Bryan Richardson 5 years ago

yes, i have added it... that is what i attached in the screenshots added for you to see.. check the screenshots in my previous post. You can also see the content of the folder for the db_updates as attached in the previous post. here i have attached them again. check the attachments for review of what you asked me to do and also the contents of the folders as it is.

0

Answered by Mian Saleem 5 years ago

Oh dear, you have added tinyint filed not hide_pos 😦 The query should look like this

ALTER TABLE `sma_products` ADD `hide_pos` TINYINT(1) NOT NULL DEFAULT '0';

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.