Comments (3)
I think I see the problem, it was my collation utf8mb4_unicode_ci makes name 1020 bytes internally. Might want to make sure collation is set with create database in config
from sitebar.
I'm not sure if I can help here, or you solved your problem by using shorter collation. I guess standard utf-8 should expand up to three characters so the limit would not be exceeded.
from sitebar.
Hi, sorry for responding to the closed issue.
I just installed sitebar today and found similar issue
Here is the error messages.
Specified key was too long; max key length is 767 bytes [ CREATE TABLE
sitebar_link
(lid
int(10) unsigned NOT NULL auto_increment,nid
int(10) unsigned NOT NULL default '0',url
text NOT NULL,name
varchar(255) NOT NULL default '',private
tinyint(1) default '0',comment
longtext,favicon
text,added
datetime NOT NULL default CURRENT_TIMESTAMP,changed
datetime,visited
datetime,tested
datetime,deleted_by
int(10) unsigned default NULL,is_dead
tinyint(1) NOT NULL default '0',is_feed
tinyint(1) NOT NULL default '0',is_sidebar
tinyint(1) NOT NULL default '0',hits
int(10) unsigned NOT NULL default '0',validate
tinyint(1) NOT NULL default '1',target
varchar(32),type
varchar(10) DEFAULT '', PRIMARY KEY (lid
), UNIQUE KEYname
(nid
,name
) ) COMMENT='Each link must belong to a node.']
Specified key was too long; max key length is 767 bytes [ CREATE TABLE
sitebar_node
(nid
int(10) unsigned NOT NULL auto_increment,nid_parent
int(10) unsigned NOT NULL DEFAULT '0',name
varchar(255) NOT NULL DEFAULT '',comment
text,sort_mode
char(10) DEFAULT 'user',custom_order
text,type
varchar(10) DEFAULT '',deleted_by
int(10) unsigned DEFAULT NULL, PRIMARY KEY (nid
), UNIQUE KEYname
(nid_parent
,name
), KEYpnid
(nid_parent
) ) COMMENT='Node contains other nodes and links.']
Specified key was too long; max key length is 767 bytes [ CREATE TABLE
sitebar_cache
(type
varchar(10) NOT NULL,ckey
varchar(255) NOT NULL,cvalue
LONGBLOB NOT NULL,created
datetime NOT NULL default CURRENT_TIMESTAMP,expires
datetime, PRIMARY KEY (type
,ckey
) ) COMMENT='Contains multipurpose cache.']
Specified key was too long; max key length is 767 bytes [ CREATE TABLE
sitebar_data
(type
varchar(10) NOT NULL,dkey
varchar(255) NOT NULL,dvalue
LONGBLOB NOT NULL, PRIMARY KEY (type
,dkey
) ) COMMENT='Offers multipurpose data storage space.']
Specified key was too long; max key length is 767 bytes [ CREATE TABLE
sitebar_user_data
(type
varchar(10) NOT NULL,uid
int(10) unsigned NOT NULL,dkey
varchar(255) NOT NULL,dvalue
LONGBLOB NOT NULL, PRIMARY KEY (type
,uid
,dkey
) ) COMMENT='Offers multipurpose user data storage space.']
Table 'sitebar.sitebar_node' doesn't exist [ INSERT INTO
sitebar_node
(nid
,nid_parent
,name
,comment
) VALUES (1, 0, 'Admin Bookmarks', 'Bookmarks of SiteBar Administrators')]
Table 'sitebar.sitebar_node' doesn't exist [ INSERT INTO
sitebar_node
(nid
,nid_parent
,name
,comment
) VALUES (2, 0, 'Public Bookmarks', NULL)]
Table 'sitebar.sitebar_node' doesn't exist [ INSERT INTO
sitebar_node
(nid
,nid_parent
,name
,comment
,sort_mode
) VALUES (3, 2, 'SiteBar Project', 'Bookmarks related to the SiteBar open source project.', 'custom')]
Table 'sitebar.sitebar_node' doesn't exist [ INSERT INTO
sitebar_node
(nid
,nid_parent
,name
,comment
,sort_mode
) VALUES (4, 2, 'Web Search', 'Type a search term in the toolbar and click on one of the links to search this term using that search engine. Using the SiteBar Sidebar Extension for Mozilla Firefox you can middle click on the folder to search all engines each in its own tab.', 'custom')]
The solution would be adding "ENGINE=InnoDB DEFAULT CHARSET=UTF8" to the end of the "CREATE TABLE" statements
I hope this would help.
from sitebar.
Related Issues (20)
- PHP 7 is still not working HOT 4
- HiDPI support / vector icons / font scaling (CSS issue)
- No Support for MySQL detected after Update from Ubuntu 16.04.02 to 16.04.03 HOT 3
- Can't add new bookmarks HOT 4
- Invalid Query HOT 2
- Problem installing/upgrading Sitebar HOT 20
- Invalid query: 1978: Incorrect default value '0000-00-00 00:00:00' for column 'expires' HOT 4
- Disable Tracy ifo HOT 1
- issue with 'Add Page to Sitebar' HOT 2
- error with 'Add to Sitebar' HOT 11
- Invalid query: 1978: Incorrect default value '0000-00-00 00:00:00' for column 'expires' HOT 1
- "Sitebar: No support for MySQL detected!" HOT 1
- Mixed content.. HOT 1
- No login to the add-on in Chrome (Win 10)
- You have to enable cookies in order to log-in or sign-up! HOT 2
- Login not possible with PHP 7.3 and 7.4 HOT 3
- Feature Request: Nginx configuration for Sitebar with multiple web-apps HOT 1
- Install failure debugged & can't import Bookmarks
- Blank page and "Unknown system variable 'innodb_version' " in php logs HOT 1
- Can't add new bookmarks and "Incorrect default value '0000-00-00 00:00:00' for column 'expires'" PHP error log HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sitebar.