Weblog
29 May 2015, 12:42
The view of the 5.0 release has completely been redesigned. Everything is now responsive, inclusing the CMS. I've used Bootstrap for this. The Banshee demo website already uses this 5.0 beta release, so you can test and see what it does.
To all Banshee users, please test this beta release and let me know of any issues. Specially layout issues.
For those who can't access the CMS due to change in the way Banshee stores passwords, use the database/set_password script.
What if I do not change anything in the Banshee v4.0 and just post some data to it? Does the upgrade smooth?
I upgraded Banshee v4.0 to v5.0 by replacing the source code and edited the website.conf. Everything looks fine except that I cannot login to the control panel via "admin" directory. Any idea?
I cannot access the "admin" page. Any idea?
When I use my Android to access my site, the following error displayed :
Internal errors :
SQL query: update log_clients set count=count+1 where os='Android' and browser='Firefox' and date='2015-06-02'
Error message: Table 'banshee log_clients' doesn't exist
When I access "login" page (i.e. admin page), the error displayed :
The requested page could not be found.
If you believe this is due to a bug in this website, please notify the webmaster. Click here to return to the homepage.
The definition of the log_clients table can be found in database/mysql.sql. Use it to create that table manually.
Note that the CMS of 5.0b can be reached via /cms, not via /admin like the previous releases.
Has the database for weblog changed, do I need an update for database?
I use the old database. With banshee 4.x I can edit.
Btw Performance seems to be fast and bootstrap is really fine.
I give up to upgrade Banshee from v4.0 to v5.0b. I tried to set a new one, however, I encounter the following errors :
root@hiawatha:/var/www/infosec/banshee-5.0b/database# ./setup_database
This script will create a MySQL user 'banshee5' and the database 'banshee5'.
Make sure the database settings in settings/website.conf are correct!
Enter MySQL admin's username [root]: root
Enter password for user root:
ERROR 1045 (28000): Access denied for user 'banshee5'@'localhost' (using password: YES)
SQL query: select value, UNIX_TIMESTAMP(timeout) as timeout from cache where `key`='settings_last_updated' limit 1
Error message: Table 'banshee5.cache' doesn't exist
SQL query: delete from cache where `key`='settings_last_updated' limit 1
Error message: Table 'banshee5.cache' doesn't exist
SQL query: select value, UNIX_TIMESTAMP(timeout) as timeout from cache where `key`='settings_last_updated' limit 1
Error message: Table 'banshee5.cache' doesn't exist
SQL query: select * from settings where `key`='secret_website_code'
Error message: Table 'banshee5.settings' doesn't exist
SQL query: insert into settings (`key`, `type`, `value`) values ('secret_website_code', 'string', 'qi24TS8Nz4aVsdMtqORhXjJ0KPScavdC')
Error message: Table 'banshee5.settings' doesn't exist
SQL query: update users set status=1
Error message: Table 'banshee5.users' doesn't exist
I confirmed that database "Banshee" is created but there is no table in it.
I have changed the website.conf to "banshee5", "banshee5" as db name and db user. The database "banshee" is for my version 4.0.
Any idea?
Make sure the user banshee5 has proper access rights.
Does your script create this user or not?
Your "setup_database" script created the user with the designed password. The password contains symbols. However, I can login with that user even v4.0 can do that without problem.
I noticed that your script has been changed since v4.0.
XSLTProcessor::transformToXml(): ID tags already defined in /var/www/users/website/libraries/xml.php on line 314.
Id tested it. I exported and imported alle tables manually. After adding (in CMS) a tag to a existing weblog I get this message.
It must be related to tags in weblog.
How can I fix it ?
Table is complete new.
Issue comes, when I have more than one tag.
What is the output when you add "?output=raw" to the URL? Please send it to my by e-mail.
Whats about the Weblog Issue?
The problem is fixed. The problem is caused by the password (with symbols). Thanks for the hints.
The password contains "$" and "*".
By the way, the "Menu" settings page buttons need to be fixed.
PHP 5.5.25 (cli) (built: May 22 2015 00:15:41)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies
The "Insert" button is too ugly.
Issue seems to be gone. You can test self again.
(0) Make sure you did not programming to version 4.0.
(1) Backup the v4.0 database by running database/backup_database.
(2) Extract the dumped database. Changed all "admin" to "cms" at "roles" table. Change "/admin" to "/cms" at "menu" data section.
(3) Still dumped database. Locate "users" table. Go to the data section. Change ",NULL,NULL,1," to ",NULL,NULL,2,"
(4) Install Banshee v5.0b. Change settings/website.conf. Make sure you change the "DB_DATABASE", "DB_USERNAME". Make sure "DB_PASSWORD" does not contain any symbol.
(5) At v5.0b directory, run database/setup_database and then run database/remove_demo_content.
(6) Copy the altered dumped database (v4.0) to the directory of database (v5.0b). Run the following command :
mysql -u [DB_USERNAME] -p[DB_PASSWORD] [DB_DATABASE] < [alterned dumped database]
(7) Still at v5.0b directory. Copy out the whole "settings" table structure and data section as well as the header of the mysql.sql (the first few lines) from mysql.sql to test.sql. Then run the following command :
mysql -u [DB_USERNAME] -p[DB_PASSWORD] [DB_DATABASE] < test.sql
(8) Now, you can access your site now. Make sure you disable the "user" account when necessary. Make sure to change "Settings" module as the data is default value.
Good luck!
@samiux: Thanks. Will point to your post at final release.
Thanks for your Hiawatha and Banshee.