Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

cached table definition is different than real table #4268

Closed
Jimmi08 opened this issue Nov 23, 2020 · 1 comment
Closed

cached table definition is different than real table #4268

Jimmi08 opened this issue Nov 23, 2020 · 1 comment
Labels
type: bug A problem that should not be happening
Milestone

Comments

@Jimmi08
Copy link
Contributor

Jimmi08 commented Nov 23, 2020

This is sql file:

CREATE TABLE userjournals (
  userjournals_id int(10) unsigned NOT NULL auto_increment,
  userjournals_userid int(10) unsigned NOT NULL default '0',
  userjournals_subject varchar(64) NOT NULL default '',
  userjournals_categories varchar(100) NOT NULL default '',
  userjournals_playing varchar(50) NOT NULL default '',
  userjournals_mood enum('','happy','sad','alienated','beat_up','angry','annoyed','chicken','confused','crying','doh','evil','funny','greedy','hungry','puzzled','innocent','shocked','sick','sleepy','very_happy') NOT NULL default 'happy',
  userjournals_entry longtext NOT NULL,
  userjournals_date varchar(64) NOT NULL default '',
  userjournals_timestamp varchar(32) NOT NULL default '',
  userjournals_is_comment int(1) NOT NULL default '0',
  userjournals_comment_parent int(1) default NULL,
  userjournals_is_blog_desc int(1) NOT NULL default '0',
  userjournals_is_published int(1) NOT NULL default '0',
  PRIMARY KEY  (userjournals_id)
) TYPE=MyISAM;
CREATE TABLE userjournals_categories (
  userjournals_cat_id int(10) unsigned NOT NULL auto_increment,
  userjournals_cat_name varchar(100) NOT NULL default '',
  userjournals_cat_icon varchar(100) NOT NULL default '',
  userjournals_cat_parent_id  int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (userjournals_cat_id)
) TYPE=MyISAM;

Cached fields:

array (
  '_FIELD_TYPES' => 
  array (
    'userjournals_id' => 'int',
    'userjournals_userid' => 'int',
    'userjournals_subject' => 'escape',
    'userjournals_categories' => 'escape',
    'userjournals_playing' => 'escape',
    'userjournals_entry' => 'escape',
    'userjournals_date' => 'escape',
    'userjournals_timestamp' => 'escape',
    'userjournals_is_comment' => 'int',
    'userjournals_comment_parent' => 'int',
    'userjournals_is_blog_desc' => 'int',
    'userjournals_is_published' => 'int',
  ),
  '_NOTNULL' => 
  array (
    'userjournals_id' => '',
    'userjournals_entry' => '',
  ),
)

Sorry, Murphy, as soon as I posted it here, I found the reason for insert() problem. But this still stays.

@Jimmi08 Jimmi08 added the type: bug A problem that should not be happening label Nov 23, 2020
@Jimmi08 Jimmi08 changed the title Not able to use insert() with this table cached table definition is different than real table Nov 23, 2020
@Jimmi08
Copy link
Contributor Author

Jimmi08 commented Nov 23, 2020

By the way,
if you do mistype in field name, you get error, which is great.
Column not found: 1054 Unknown column 'ouserjournals_is_comment' in 'field list'
but if you do mistype with space f.e. 'userjournals_is_comment ' there is no similar error.

@CaMer0n CaMer0n added this to the e107 2.3.0 milestone Nov 29, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: bug A problem that should not be happening
Projects
None yet
Development

No branches or pull requests

2 participants