the
>>>> referenced column. Did the create statements come from your create
>>>> scripts
>>>> or from a show create table statement? I'm suspicious about the
>>index on
>>>> virtual_users(user).
>>>>
>>>>
>>>> -
the create statements come from your create
>>> scripts
>>> or from a show create table statement? I'm suspicious about the
>index on
>>> virtual_users(user).
>>>
>>>
>>> ----- Original Message -
>>>> From: "David Mehler"
er).
>>
>>
>> - Original Message -
>>> From: "David Mehler" <dave.meh...@gmail.com>
>>> To: "MySql" <mysql@lists.mysql.com>
>>> Sent: Tuesday, 25 April, 2017 23:07:19
>>> Subject: Re: Can not add foreign key cons
Hello,
Tried recreating the virtual_users table didn't solve anything. Would
it be possible for anyone to check out my box directly?
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 20:47, David Mehler wrote:
>> Hello,
>>
>> Thanks. Here's the create
On 4/24/2017 20:47, David Mehler wrote:
Hello,
Thanks. Here's the create statements for virtual_domains,
virtual_users, and the one that isn't working lastauth:
CREATE TABLE `virtual_domains` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
)
Hello,
Thanks. Here's the create statements for virtual_domains,
virtual_users, and the one that isn't working lastauth:
CREATE TABLE `virtual_domains` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE
Hello,
I'm running Mysql 5.7.18.
My virtual_users are working fine, it's the new table that isn't. Or
am I missing something?
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 17:41, David Mehler wrote:
>> Hello,
>>
>> Here's the output. I hope it
Hello,
Here's the output. I hope it helps.
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT NULL,
-> `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON
UPDATE CURRENT_TIMESTAMP,
-> PRIMARY KEY
On 4/24/2017 15:28, Peter Brawley wrote:
On 4/24/2017 13:59, David Mehler wrote:
Hello,
root@localhost [mail]> show engine innodb_status;
ERROR 1286 (42000): Unknown storage engine 'innodb_status'
Well it's very unlikely InnoDB made that up, it's probably in one of
your Create texts.
Ah,
On 4/24/2017 2:10 PM, Peter Brawley wrote:
On 4/24/2017 12:28, David Mehler wrote:
...snip
Adding in a dummy Create Table for the missing referenced
`virtual_domains`, we have ...
drop table if exists lastauth, virtual_users, virtual_domains;
CREATE TABLE virtual_domains (
id int
Hello,
Here's the engines I have:
root@localhost [(none)]> show engines;
++-++--+--++
| Engine | Support | Comment
| Transactions | XA |
On 4/24/2017 13:59, David Mehler wrote:
Hello,
root@localhost [mail]> show engine innodb_status;
ERROR 1286 (42000): Unknown storage engine 'innodb_status'
Well it's very unlikely InnoDB made that up, it's probably in one of
your Create texts.
PB
-
This is on a Mysql 5.7 setup.
Hello,
root@localhost [mail]> show engine innodb_status;
ERROR 1286 (42000): Unknown storage engine 'innodb_status'
This is on a Mysql 5.7 setup.
Thanks.
Dave.
On 4/24/17, Peter Brawley wrote:
> On 4/24/2017 12:28, David Mehler wrote:
>> Hello,
>>
>>Here's
On 4/24/2017 12:28, David Mehler wrote:
Hello,
Here's the create table sand error message.
root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT
Hello,
Here's the create table sand error message.
root@localhost [(none)]> use mail;
Database changed
root@localhost [mail]> CREATE TABLE IF NOT EXISTS `lastauth` (
-> `user` varchar(40) NOT NULL,
-> `remote_ip` varchar(18) NOT NULL,
-> `timestamp` timestamp NOT NULL
15 matches
Mail list logo