• You MUST read the Babiato Rules before making your first post otherwise you may get permanent warning points or a permanent Ban.

    Our resources on Babiato Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If your are on Windows and have an antivirus that alerts you about a possible infection: Know it's a false positive because all scripts are double checked by our experts. We advise you to add Babiato to trusted sites/sources or disable your antivirus momentarily while downloading a resource. "Enjoy your presence on Babiato"

SalePro - Inventory Management System with POS, HRM, Accounting

SalePro - Inventory Management System with POS, HRM, Accounting v4.5.1

No permission to download
Overview Updates (35) Reviews (2) History Discussion
i figure it out that on the sale the discount can low the price lower than the cost of the product, any1 knows how can i fix it with showing an alert that says that the discount cannot be lower than the cost of the product?
 
ramen03 said:
1680554513060.png
IM HAVING THIS ERROR ON THE WAREHOUSE CREATE AND USER
Click to expand...
Hi brow,
Try to Run this SQL query :

ALTER TABLE `warehouses`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

I hope this helps :)
 
theshadowwalker said:

SalePro 3.7.6 nulled​

VERSION 3.7.6 3 APRIL 23​

Fixed: Currency issue fixed

VERSION 3.7.5 30 MARCH 23​

Added: Custom field feature added for Sale and Customers.
Added: Currency switch option added for sale, purchase and return. Now user can switch currency during transaction without going to setting.
Added: All the common database queries are cached.
Added: A button added on the top navigation bar to create all necessary section like customer, products etc.
Updated: Page speed highly improved.
Updated: Account Statement sorting feature updated
Updated: Product adding issue fixed in POS page.
Updated: Customer report, User report, warehouse report, customer due report updated. Now it comes with server side rendering
Updated: Main admin layout updated
Fixed: Decimal issues related to invoice fixed.

Screenshot (3).png Screenshot (4).png Screenshot (5).png Screenshot (6).png
Click to expand...
Link not working, file deleted, please upload it again
And i have issues when i am trying to show or add supplier
Please help me.
 

Attachments

  • Untitlwwed.jpg
    Untitlwwed.jpg
    200.6 KB · Views: 19
How to null the version 3.7.8 17 23

Open the file:
Code: 
..\public\install\step4.php

Change the line #24
Code: 
if ($object->codecheck) {

To this:
Code: 
if (1 == 1) {

Change the line #49
Code: 
$dbh->exec($object->dbdata);

to those lines:
Code: 
$query = file_get_contents("salepro.sql");
 $dbh->exec($query);

Add double line "//" to comment those lines from the line #52 to line #63
Code: 
//if ($e->getCode() == 2002) {
//            header('location: step3.php?_error=Unable to Connect Database, Please make sure Host info is correct and try again !');
//            exit;
//        }
//        elseif ($e->getCode() == 1045) {
//            header('location: step3.php?_error=Unable to Connect Database, Please make sure database username and password is correct and try again !');
//            exit;
//        }
//        elseif ($e->getCode() == 1049) {
//            header('location: step3.php?_error=Unable to Connect Database, Please make sure database name is correct and try again !');
//            exit;
//        }

Delete or comment the line #66
Code: 
//   header("location: step3.php?_error=Wrong Purchase Code !");

Add this SQL file named to the folder :
Code: 
..\public\install\step4.php

SalePro 3.7.8 anulado​

 

Attachments

  • salepro Database v3.7.8.zip
    50.7 KB · Views: 45
Last edited:
  • Like
Reactions: Asheni21, merdate, nyekla and 1 other person
Please share this new version 🙏

Version 3.7.9 5 June 23​

Added: Table(Restaurant) feature added.
Added: Table management(Restaurant) option in the POS setting
Added: Option to select table(Restaurant) on the POS page.
Added: Table and queue no in the invoice.
Added: Logo in the A4 invoice.
Added: Dynamic documentation
Added: Indonesian language added.
Fixed: Minor bugs fixed.
 
After install, it gives me this error:
Illuminate\Database\QueryException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pos.general_settings' doesn't exist (SQL: select * from `general_settings` order by `created_at` desc limit 1)

If I create that table manually, the error goes away, but I get another one that says
public/tenant_necessary.sql file is missing.
 
Last edited:
  • Haha
Reactions: enigmahernandez
merdate said:
After install, it gives me this error:
Illuminate\Database\QueryException
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'pos.general_settings' doesn't exist (SQL: select * from `general_settings` order by `created_at` desc limit 1)

If I create that table manually, the error goes away, but I get another one that says
public/tenant_necessary.sql file is missing.
Click to expand...
read the requeriments sir, read read...
 
macrobert updated SalePro - Inventory Management System with POS, HRM, Accounting with a new update entry:

SalePro - POS, Inventory Management System with HRM & Accounting

Added: Table(Restaurant) feature added.
Added: Table management(Restaurant) option in the POS setting
Added: Option to select table(Restaurant) on the POS page.
Added: Table and queue no in the invoice.
Added: Logo in the A4 invoice.
Added: Dynamic documentation
Added: Indonesian language added.
Fixed: Minor bugs fixed.
Click to expand...

Read the rest of this update entry...
 
How to null the version 3.7.9:

Open the file:
Code: 
..\public\install\step4.php

Change the line #24
Code: 
if ($object->codecheck) {

To this:
Code: 
if (1 == 1) {

Change the line #49
Code: 
$dbh->exec($object->dbdata);

to those lines:
Code: 
$query = file_get_contents("salepro.sql");
 $dbh->exec($query);

Add double line "//" to comment those lines from the line #52 to line #63
Code: 
//if ($e->getCode() == 2002) {
//            header('location: step3.php?_error=Unable to Connect Database, Please make sure Host info is correct and try again !');
//            exit;
//        }
//        elseif ($e->getCode() == 1045) {
//            header('location: step3.php?_error=Unable to Connect Database, Please make sure database username and password is correct and try again !');
//            exit;
//        }
//        elseif ($e->getCode() == 1049) {
//            header('location: step3.php?_error=Unable to Connect Database, Please make sure database name is correct and try again !');
//            exit;
//        }

Delete or comment the line #66
Code: 
//   header("location: step3.php?_error=Wrong Purchase Code !");

Add this SQL file named to the folder :
Code: 
..\public\install\step4.php

SALE PRO NULLED WORKING 100% FULL WHITOUT ERRORS​

 

Attachments

  • salepro.zip
    50.7 KB · Views: 24
  • salepro-3.8.0-nulled_clean.zip
    40.8 MB · Views: 19
Last edited:
  • Like
Reactions: tisna98
Finally I've found the error, it wasn't my fault, it's your file salepro.sql that is wrong.
You should delete line 23 and 24 from that file (the CREATE and USE salepro_db queries) to make it universal.
Furthermore it gave error because of that collation not present in all mysql installations.
 
  • Haha
Reactions: enigmahernandez
merdate said:
Finally I've found the error, it wasn't my fault, it's your file salepro.sql that is wrong.
You should delete line 23 and 24 from that file (the CREATE and USE salepro_db queries) to make it universal.
Furthermore it gave error because of that collation not present in all mysql installations.
Click to expand...
The CREATE query is universal to be able to create it when having old versions, that's why it is not deleted and left.
So understand the file ENV, the database named in config, must be same as like lines #23 and #24

Code: 
CREATE DATABASE IF NOT EXISTS `salepro_db` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE `salepro_db`;

In any case, it is your way of importing that is wrong.
 
Last edited:
enigmahernandez said:
The CREATE query is universal to be able to create it when having old versions, that's why it is not deleted and left.
So understand the file ENV, the database named in config, must be same as like lines #23 and #24

Code: 
CREATE DATABASE IF NOT EXISTS `salepro_db` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
USE `salepro_db`;

In any case, it is your way of importing that is wrong.
Click to expand...
As I said before, the main problem is in COLLATE clause, that generates an error and makes the installation fail, as well as the USE query (why do you provide your own db name if you let the user choose it in the second step?).
However I'm not importing the dump manually, I did only once to debug, because it failed during installation.
If you delete that two lines, the whole process goes well as you explained in your tutorial.
 
  • Like
Reactions: enigmahernandez
You must log in or register to reply here.

Similar threads

asiandoll
Point of sale to WooCommerce add-on for SalePro POS & inventory management php script
Replies
1
Views
104
PHP Scripts
Babak
Babak
khenji
eCommerce Add-on for SalePro POS, inventory Management App
Replies
1
Views
272
PHP Scripts
Babak
Babak
Alex25397
PosKing - Point Of Sale System with Inventory Management | Retail Business ERP
Replies
1
Views
308
PHP Scripts
Babak
Babak
DLSR
ERP OS - ERP, POS, Inventory, Invoice Software
Replies
2
Views
576
PHP Scripts
MR.X7
M
DLSR
Inventory OS - Inventory & Shop Manage
Replies
1
Views
356
PHP Scripts
Babak
Babak

Latest posts

Forum statistics

Threads
79,603
Messages
1,146,071
Members
250,556
Latest member
sirlord

Share this page

Share this page
Top Bottom
Back
AdBlock Detected

We get it, advertisements are annoying!

However in order to keep our huge array of resources free of charge we need to generate income from ads so to use the site you will need to turn off your adblocker.

If you'd like to have an ad free experience you can become a Babiato Lover by donating as little as $5 per month. Click on the Donate menu tab for more info.

I've Disabled AdBlock