#145 ipplanv6-CVS: Index creation fails, missing field in table

closed
nobody
None
5
2011-07-11
2011-04-13
Anonymous
No

Error:

---
ALTER TABLE ipaddrlnk ADD INDEX ipaddrlnk_dst (dstipaddr, dstcustomer);

Failed to execute above statement against database
Key column 'dstcustomer' doesn't exist in table
---

Looking at schemacreate.php I see:

---
$tables['ipaddrlnk']=array(
array('ipaddr', 'C', '39', 'DEFAULT' => '', 'NotNull'),
# array('iptype','I4','DEFAULT' => AFI_INET),
array('baseindex', 'I8', 'DEFAULT' => 0, 'NotNull'),
array('customer', (DBF_TYPE=='mysql' or DBF_TYPE=='maxsql') ? 'SMALLINT UNSIGNED':'I4', 'DEFAULT' => 0, 'NotNull'),
array('dstipaddr', 'C', '39', 'DEFAULT' => '', 'NotNull'),
array('dstbaseindex', 'I8', 'DEFAULT' => 0, 'NotNull'),
);
---

The field 'dstcustomer' exists on a 4.91a install but no in ipplanv6.

Regards,

Discussion

  • Richard Ellerbrock

    • status: open --> closed
     
  • Richard Ellerbrock

    Resolved in CVS

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks