MySQL Error Invalid Table or Database Name

-
We upgraded our MySQL server recently which ran several Joomla web sites

After the upgrade we discovered the following error in the mysql log files

090425 23:10:52 [ERROR] Invalid (old?) table or database name 'database-name'

It turns out MySQL does not like the use of - in database names.

One solution is to rename the MySQL database changing the - to an _

Then update the mysql dictionary

UPDATE mysql.db SET Db = 'database_name' WHERE Db = 'database\-name';
FLUSH PRIVILEGES;













































Comments















Post a Comment



















Popular posts from this blog









Basic Send Message to MQ with Java and IBM MQ JMS






-















package my.mq.samples;


import javax.jms.JMSException;

import javax.jms.Session;

import javax.jms.TextMessage;


import com.ibm.mq.jms.MQQueue;


import com.ibm.mq.jms.MQQueueConnection;

import com.ibm.mq.jms.MQQueueConnectionFactory;

import com.ibm.mq.jms.MQQueueSender;

import com.ibm.mq.jms.MQQueueSession;

import com.ibm.msg.client.wmq.WMQConstants;


public class MQSend {

public static void main(String[] args)
{
try {
MQQueueConnectionFactory cf = new MQQueueConnectionFactory();
cf.setHostName("localhost");
cf.setPort(1414);

cf.setIntProperty(WMQConstants.WMQ_CONNECTION_MODE, WMQConstants.WMQ_CM_CLIENT);

cf.setQueueManager("QM_GRIDSERVER");
cf.setChannel("SYSTEM.ADMIN.SVRCONN");

MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection();
//MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection("username","password");

MQQueueSession session = (MQQueueSession) connection.createQueueSession(false, Session.AUTO_ACKN…








Read more










Basic Receive Message to MQ with Java and IBM MQ JMS






-















package my.mq.samples;


import javax.jms.JMSException;

import javax.jms.Session;

import javax.jms.TextMessage;

import com.ibm.mq.jms.MQQueue;

import com.ibm.mq.jms.MQQueueConnection;

import com.ibm.mq.jms.MQQueueConnectionFactory;

import com.ibm.mq.jms.MQQueueReceiver;

import com.ibm.mq.jms.MQQueueSession;

import com.ibm.msg.client.wmq.WMQConstants;


public class MQReceive {

public static void main(String[] args)
{
try {
MQQueueConnectionFactory cf = new MQQueueConnectionFactory();
cf.setHostName("localhost");
cf.setPort(1414);

cf.setIntProperty(WMQConstants.WMQ_CONNECTION_MODE, WMQConstants.WMQ_CM_CLIENT);

cf.setQueueManager("QM_GRIDSERVER");
cf.setChannel("SYSTEM.ADMIN.SVRCONN");

MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection();
//MQQueueConnection connection = (MQQueueConnection) cf.createQueueConnection("username","password");

MQQueueSession session = (MQQueueSession) connection.createQueueSession(false, Session.AUTO…








Read more










Creating a simple Alert / Success Message with ASP.NET/VB using Bootstrap






-















In your AddContact.aspx page use something like the following


      <div class="row-fluid">

            <div class="span6">

                <h2>New Contact</h2>

            </div>

            <div class="span6">

                <asp:Label ID="AlertWindow" Visible="false" CssClass="alert alert-success" runat="server"></asp:Label>

            </div>

        </div>


And in your AddContact.aspx.vb code use something similar to this.  Basically set the message for the alert window, make the alert window visible and set the approprate css style.  You can make this  alot cleaner with a set of classes to implement bootstrap for ASP.NET.  So this is just an example. 


    ...... 

    ...... 

    AlertWindow.Visible = True 

    Try

        ...... 

        sSQLQuery = "INSERT INTO......"

        ...... 

        AlertWindow.Text = "New Contact Added Succes…








Read more