te 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 -
>>>&g
tements 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"
>>
rs(user).
>>
>>
>> - Original Message -
>>> From: "David Mehler"
>>> To: "MySql"
>>> Sent: Tuesday, 25 April, 2017 23:07:19
>>> Subject: Re: Can not add foreign key constraint
>>
>>> Hello,
>>&g
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 statements for virtual_domains
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`)
) ENGI
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 TABLE
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 helps.
>>
>> root@localhost [mail
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, a
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 PRIMA
Hello,
Here's the engines I have:
root@localhost [(none)]> show engines;
++-++--+--++
| Engine | Support | Comment
| Transactions | XA | S
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.
Th
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 the create table sand error me
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 DE
15 matches
Mail list logo
