Support Center » Knowledgebase » SQL Error DB function failed with error number 1146
 SQL Error DB function failed with error number 1146
Solution

Installation fails with error
SQL Error DB function failed with error number 1146

You have received this error because your database is not using 'jos' as its prefix. Your database prefix is specified in Global Configuration / System / Database

To fix this error, open the 'install.component.sql' file in the package in notepad or your chosen file editor

Replace all occurrences of 'jos_', with your database prefix

Save the file, then zip up the installation folder and reinstall the component

Note: in older versions of our components the SQL statements are in the file 'install.component.php' or in the component XML file. In this case the same replacement should be made in the SQL statements in these files

If you let us know what your database prefix is we can change the code to suit your needs.



Article Details
Article ID: 8
Created On: 13 Nov 2007 05:01 PM

 This answer was helpful  This answer was not helpful

 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | Downloads
Language:

Help Desk Software By Kayako SupportSuite v3.11.01