goFrendiAsgard / No-CMS

No-CMS, A CodeIgniter Based CMS Framework
299 stars 199 forks source link

Database error, Modulgenerator #121

Closed alwin4711 closed 9 years ago

alwin4711 commented 9 years ago

If i make a new modul with database and i try to use the Manage xxx button i got a....

The table exist and is accessible via phpmyadmin If i put a print $this->basic_db_table in the File C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php file near by Line Number: 4725 I will see the correct tablename, for example cms_alwin_2_notizen


Type: Exception

Message: The table name does not exist. Please check you database and try again.

Filename: C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php

Line Number: 4725

Backtrace:

File: C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php Line: 4233 Function: get_table

File: C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php Line: 4249 Function: pre_render

File: C:\xampp\htdocs\no-cms\application\libraries\Extended_grocery_crud.php Line: 1532 Function: render

File: C:\xampp\htdocs\no-cms\modules\alwin_2\controllers\Manage_notizen.php Line: 191 Function: render

File: C:\xampp\htdocs\no-cms\index.php Line: 455 Function: require_once

goFrendiAsgard commented 9 years ago

Is there any sql error? On Apr 23, 2015 5:53 PM, "Alain Lasserre" notifications@github.com wrote:

If i make a new modul with database and i try to use the Manage xxx button i got a....

The table exist and is accessible via phpmyadmin If i put a print $this->basic_db_table in the File C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php file near by Line Number: 4725

I will see the correct tablename, for example cms_alwin_2_notizen

Type: Exception

Message: The table name does not exist. Please check you database and try again.

Filename: C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php

Line Number: 4725

Backtrace:

File: C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php Line: 4233 Function: get_table

File: C:\xampp\htdocs\no-cms\application\libraries\Grocery_crud.php Line: 4249 Function: pre_render

File: C:\xampp\htdocs\no-cms\application\libraries\Extended_grocery_crud.php Line: 1532 Function: render

File: C:\xampp\htdocs\no-cms\modules\alwin_2\controllers\Manage_notizen.php Line: 191 Function: render

File: C:\xampp\htdocs\no-cms\index.php Line: 455 Function: require_once

— Reply to this email directly or view it on GitHub https://github.com/goFrendiAsgard/No-CMS/issues/121.

alwin4711 commented 9 years ago

No Sir....;-) -- phpMyAdmin SQL Dump -- version 4.4.2

-- http://www.phpmyadmin.net

-- Host: localhost -- Erstellungszeit: 23. Apr 2015 um 14:00 -- Server-Version: 5.6.24-log -- PHP-Version: 5.6.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

/_!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SETCLIENT */; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SETRESULTS /; /_!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATIONCONNECTION /; /_!40101 SET NAMES utf8 */;

-- Datenbank: no_cms


-- Tabellenstruktur für Tabelle cms_alwin_2_notizen

CREATE TABLE IF NOT EXISTS cms_alwin_2_notizen ( id int(20) unsigned NOT NULL, Text mediumtext, create_time datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Indizes der exportierten Tabellen

-- Indizes für die Tabelle cms_alwin_2_notizen

ALTER TABLE cms_alwin_2_notizen ADD PRIMARY KEY (id);

-- AUTO_INCREMENT für exportierte Tabellen

-- AUTO_INCREMENT für Tabelle cms_alwin_2_notizen

ALTER TABLE cms_alwin_2_notizen MODIFY id int(20) unsigned NOT NULL AUTOINCREMENT; /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SETCLIENT */; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SETRESULTS /; /_!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

goFrendiAsgard commented 9 years ago

Can you please send me the generated module? I'm now working on development version, so things might be different.

On Thu, Apr 23, 2015 at 7:01 PM, Alain Lasserre notifications@github.com wrote:

No Sir....;-) -- phpMyAdmin SQL Dump -- version 4.4.2 -- http://www.phpmyadmin.net

-- Host: localhost -- Erstellungszeit: 23. Apr 2015 um 14:00 -- Server-Version: 5.6.24-log -- PHP-Version: 5.6.3

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";

/ _!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SETCLIENT */; /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SETRESULTS /; /_!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATIONCONNECTION /; /_!40101 SET NAMES utf8 */;

-- Datenbank: no_cms

-- Tabellenstruktur für Tabelle cms_alwin_2_notizen

CREATE TABLE IF NOT EXISTS cms_alwin_2_notizen ( id int(20) unsigned NOT NULL, Text mediumtext, create_time datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- Indizes der exportierten Tabellen -- Indizes für die Tabelle cms_alwin_2_notizen

ALTER TABLE cms_alwin_2_notizen ADD PRIMARY KEY (id); -- AUTO_INCREMENT für exportierte Tabellen -- AUTO_INCREMENT für Tabelle cms_alwin_2_notizen

ALTER TABLE cms_alwin_2_notizen MODIFY id int(20) unsigned NOT NULL AUTOINCREMENT; / !40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SETCLIENT */; /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SETRESULTS /; /_!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

— Reply to this email directly or view it on GitHub https://github.com/goFrendiAsgard/No-CMS/issues/121#issuecomment-95560069 .


Go Frendi Gunawan.

alwin4711 commented 9 years ago

send by email

goFrendiAsgard commented 9 years ago

This one should work: https://github.com/goFrendiAsgard/No-CMS/tree/e22d789048fe5105a85187cbaa5ae30500980e25 Please re-open the issue or make a new one if you find problem with this.