BLOB/TEXT column 'value' can't have a default value
CREATE TABLE IF NOT EXISTS ci_settings ( id INT(11) UNSIGNED AUTO_INCREMENT, name VARCHAR(255) DEFAULT '0', value TEXT DEFAULT '', PRIMARY KEY id (id), KEY name (name) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
hi all ! in modules management, i see next a problem about "uninstall module" and i had fixed action uninstall. someone review for me ! first setup.xml . I change and add new query with table's modules used. then i fix in module.php of admin with code:
if (is_readable(APPPATH.'modules/'.$module.'/setup.xml'))
{
$this->load->helper('xml');
$xmldata = join('', file(APPPATH.'modules/'.$module.'/setup.xml'));
$xmlarray = xmlize($xmldata);
if (isset($xmlarray['module']['#']['uninstall']0?['#'])){
$xmluninstall_query = $xmlarray['module']['#']['uninstall']0?['#']['query'];
foreach($xmluninstall_query as $row){
$this->db->query($row['#']);
}
}
}
test uninstall and install. tables's module have been drop out of db.
About the wrong redirect, you should not touch the Codeigniter Core.
Normally when you logout you are redirected to the last uri, but in Admin, since the last uri needs you to be logged in, you are redirected again to the login form. Not to the base url. At least, that's what happens to me when using the latest revision in SVN
I just download ci-cms and then i try to install to my computer. But when i write the url http://localhost/ci-cms/, the browser is going back to the root of webserver that is used (http://localhost/xampp/). Even i write the url http://localhost/ci-cms/install, the ci-cms didn't installed too. Please anyone can help me and give me explanation about my problem.
@senowijayanto,I also experienced the same thing, when I type the url :localhost /ci-cms/install, the page that appears is the XAMPP pages with url: http://localhost/xampp/splash.php, the solution is how it??
Hey hello! Have some troubles with css and Js files. I have installed the system, everything is fine. But the CSS and JS files are not included. When I try to access http://localhost/ci-cms/application/views/admin/style/admin.css , I see the CI-CMS Not Found page - " Page Not Found!
My .htaccess is placed in /var/www/ci-cms, and it's content is: RewriteEngine? on RewriteCond? $1 !^(index\.php|images|robots\.txt) RewriteRule? ^(.)$ /ci-cms/index.php/$1 L?
gowravvishwakarma> It's been fixed with the latest svn commit. In fact, if your php accepts short tags then there should be no problem. But I saw that php5, by default, deactivates short tags. So everything with <?= is not recognized.
where SQL to setup CI CMS ?
You don't need.
Just open yoursite.com/install
A Database Error Occurred
Error Number: 1101
BLOB/TEXT column 'value' can't have a default value
CREATE TABLE IF NOT EXISTS ci_settings ( id INT(11) UNSIGNED AUTO_INCREMENT, name VARCHAR(255) DEFAULT '0', value TEXT DEFAULT '', PRIMARY KEY id (id), KEY name (name) ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
After instal with some error default for TEXT type in mysql.
I can't access to admin page,or site page! I have config : $config['base_url'] = "http://localhost/ci-cms/"; $config['index_page'] = "index.php";
and rewrite not work, i have enable mod_write in apache.
Please help me. Thanks.
I saw a problem about redirect, when i login admin page and logout then. redirect return to url http://localhost/ and i fixed it such as:
find line 535 in url_helper.php and add new $uri=$config['base_url'].$uri;
find line 14 in config/config.php fix base_url key is: http://localhost/ci-cms/
i test complete all function admin and frontend site. it's ok.
hi all ! in modules management, i see next a problem about "uninstall module" and i had fixed action uninstall. someone review for me ! first setup.xml . I change and add new query with table's modules used. then i fix in module.php of admin with code:
if (is_readable(APPPATH.'modules/'.$module.'/setup.xml'))
test uninstall and install. tables's module have been drop out of db.Hi tibeopro:
About the wrong redirect, you should not touch the Codeigniter Core.
Normally when you logout you are redirected to the last uri, but in Admin, since the last uri needs you to be logged in, you are redirected again to the login form. Not to the base url. At least, that's what happens to me when using the latest revision in SVN
tibeopro> About dropping the table, I would be a bit careful because the table might have data.
Maybe there should be a confirmation form first and a checkbox asking if the admin would like to delete the table when uninstalling.
tibeopro> about the redirect
I think the error is just because of URL rewritting.
So to fix it, you just need to add the directory name in .htaccess
for http://localhost/ci-cms
You add the ci-cms in .htaccess
Hi all,
I just download ci-cms and then i try to install to my computer. But when i write the url http://localhost/ci-cms/, the browser is going back to the root of webserver that is used (http://localhost/xampp/). Even i write the url http://localhost/ci-cms/install, the ci-cms didn't installed too. Please anyone can help me and give me explanation about my problem.
Just read the comment above what you posted... You have to touch your .htaccess
@senowijayanto,I also experienced the same thing, when I type the url :localhost /ci-cms/install, the page that appears is the XAMPP pages with url: http://localhost/xampp/splash.php, the solution is how it??
Hey hello! Have some troubles with css and Js files. I have installed the system, everything is fine. But the CSS and JS files are not included. When I try to access http://localhost/ci-cms/application/views/admin/style/admin.css , I see the CI-CMS Not Found page - " Page Not Found!
The page you're looking for couldn't be found!
You can create it here "
Even when I try to access http://localhost/ci-cms/license.txt, I see this "Not Found" page. How can I fix it?
Thank you.
how is your .htaccess ?
My .htaccess is placed in /var/www/ci-cms, and it's content is: RewriteEngine? on RewriteCond? $1 !^(index\.php|images|robots\.txt) RewriteRule? ^(.)$ /ci-cms/index.php/$1 L?
Change it to
you forgot the |application|
Ooo, great!!! Thank you!! :)
http://localhost/ci-cms/admin/<?=site_url('admin/login')> just seeing this after click on any link even after login
gowravvishwakarma> It's been fixed with the latest svn commit. In fact, if your php accepts short tags then there should be no problem. But I saw that php5, by default, deactivates short tags. So everything with <?= is not recognized.
Please download from http://ci-cms.googlecode.com/svn/trunk/
Especially the admin module in
http://ci-cms.googlecode.com/svn/trunk/application/modules/admin/
lots of issues in installation, so not of use... :(
hi i couldn't reached to install pages, only see 404 error pages,after rename and edit into database step. could you help me how can i resolve it?
Can i hide CI-CMS copyright link in bottom?
@bakshir > I think t is in the template footer. You can remove it or change templates
tnx