Advertisement
NittyGritty

Emoncms-MySQL-Issue

Nov 15th, 2019
328
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. mysql> use emoncms;
  2. Reading table information for completion of table and column names
  3. You can turn off this feature to get a quicker startup with -A
  4.  
  5. Database changed
  6.  
  7. mysql> show tables
  8. -> ;
  9. +-------------------+
  10. | Tables_in_emoncms |
  11. +-------------------+
  12. | app_config |
  13. | dashboard |
  14. | event |
  15. | event_settings |
  16. | feeds |
  17. | graph |
  18. | input |
  19. | multigraph |
  20. | rememberme |
  21. | schedule |
  22. | sync |
  23. | tasks |
  24. | users |
  25. +-------------------+
  26. 13 rows in set (0.00 sec)
  27.  
  28. mysql> describe tasks;
  29. +-------------+------------+------+-----+---------+----------------+
  30. | Field | Type | Null | Key | Default | Extra |
  31. +-------------+------------+------+-----+---------+----------------+
  32. | id | int(11) | NO | PRI | NULL | auto_increment |
  33. | userid | int(11) | NO | | NULL | |
  34. | name | text | YES | | NULL | |
  35. | description | text | YES | | NULL | |
  36. | tag | text | YES | | NULL | |
  37. | run_on | int(10) | YES | | 0 | |
  38. | frequency | text | YES | | NULL | |
  39. | processList | text | YES | | NULL | |
  40. | time | int(10) | YES | | NULL | |
  41. | enabled | tinyint(4) | YES | | NULL | |
  42. +-------------+------------+------+-----+---------+----------------+
  43. 10 rows in set (0.02 sec)
  44.  
  45. mysql> ALTER TABLE `tasks` MODIFY `description` text DEFAULT '';
  46. ERROR 1101 (42000): BLOB, TEXT, GEOMETRY or JSON column 'description' can't have a default value
  47. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement