500 – An error has occurred! DB function failed with error number 126 Incorrect key file for table ‘/tmp/#sql_54d6_0.MYI’; try to repair it SQL=SELECT c.*, g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM jos_content AS c LEFT JOIN jos_categories AS cc ON cc.id = [...]
A few days ago, Oracle, a company which is known by it’s RDBMS, Oracle Database, bought Sun Microsystems ($7.4 billion.. wheewwww), a company which is known by it’s famous programming language, Java. As we know, Sun had bought MySQL, the famous open source database. Hmm… can you imagine how big Oracle now? I just wonder [...]
jtablesession::Store Failed DB function failed with error number 145 Table ‘./joomla_database/jos_session’ is marked as crashed and should be repaired SQL=INSERT INTO `jos_session` (`session_id`,`time`,`username`,`gid`,`guest`,`client_id`) VALUES (’1ecb458814b53d190db10cafee822dc0′,’1237429551′,”’0′,’1′,’0′); Error message above usually happens to CMS Joomla. One of Joomla tables jos_session (the table name depends on prefix) is crash. Don’t worry if you experience this problem. It’s easy [...]
There are a few ways to create a database (known as schema) in MySQL, such as using command line or third party software. Using Command Line If we decide to use command line, then we must know the syntax to create it. It’s pretty simple: CREATE DATABASE database_name. Of course we should have a MySQL [...]
To connect a Java application with MySQL, we need a driver as interface between Java and MySQL. Driver can be downloaded from the official MySQL website. [ Download MySQL Connector ] Extract downloaded file (file type: *.jar). Copy that file to directory [jre installation]/lib/ext/. Ok, your Java application is ready to connect with MySQL.