When I install joomla with latest version mysql database I get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM CHARACTER SET `utf8`’ at line…
This is because there’s some change with the new version mysql which has replaced TYPE with ENGINE. In order to get it working, we need to edit the mysql file in joomla pack:
ENGINE = MyISAM
Then go ahead to install joomla again, it will be working.
Joomla Generator Tag
Joomla will generate some meta tags by default. One of them is "generator" tag. You can see the code by opening Page Source in your Browser. This is the line generated by joomla and maybe for security purpose you want to get rid of:
<meta name="Generator" content="Joomla! – Copyright (C) 2005 – 2010 Open Source Matters. All rights reserved." />
Removing the code
For old version Joomla, we will remove this code by commenting out a line in file called frontend.php. It`s located in includes folder. If you have a local Joomla installation just edit the file, if your files are online, use FTP Client to download and then upload the file.
All you have to do is open file frontend.php and find the line called
$mainframe->addMetaTag( ‘Generator’, $_VERSION->PRODUCT . " – " . $_VERSION->COPYRIGHT);
when you locate it, put // before this line or simply remove those code.
Save the file, and refresh your site. The line should be deleted.
For New version Joomla, you need to find in /libraries/joomla/document/html/renderer/head.php and remove or comment out this line:
$strHtml .= $tab.’<meta name="generator" content="’.$document->getGenerator().’" />’.$lnEnd;
When you publish an article with Joomla, the publish status is "Pending". Mostly it’s because the Joomla site time zone settings. you can follow the below steps to fix it.
1. Go to the Joomla site Global Configuration and make sure that you have the default time zone set to your time zone. If that is correct, then go under the User Manager and edit your user account and make sure that the time zone set in it is correct.
2. Go to the article editor page and then click "Parameters – Articles". The time for "Start Publishing date" and the "End Publishing date" should set the same and not a future date. If that field is set to a future date, the article will not show up until the date in the field.
3. If you set your computer timezone or time to something different you will also need to be aware of it.