How do I figure out this error? MySqli Error: Unknown column 't0.full_name' in 'field list'

How do I figure out this error? MySqli Error: Unknown column 't0.full_name' in 'field list'

Login or register to post comments

3 replies [Last post]

Tue, 07/13/2010 - 02:00

kingwithin

Offline

Joined: 12/10/2008

I made some adjustments which shouldn't have touched the database, and now I get this error:

MySqli Error: Unknown column 't0.full_name' in 'field list'

// Perform the Query, Get the First Row, and Instantiate a new User object

$objDbResult = $objQueryBuilder->Database->Query($strQuery);

I get the error in this file from the call stack:

/includes/data_classes/generated/UserGen.class.php

Tue, 07/13/2010 - 11:10

#1

cmpscabral

Offline

Joined: 08/12/2009

In your configuration file, turn profiling on and check the queries performed. You can use phpMyAdmin to run those queries and figure out what's wrong.

Also, if you changed your database structure, be sure to run the code generator again.

Tue, 07/13/2010 - 15:18

#2

VexedPanda

Offline

Joined: 03/31/2008

This means that UserGen is expecting a column named full_name to exist in the User table, but the database can't find it.

It sure sounds like your database has changed since the last codegen.

Tue, 07/13/2010 - 15:38

#3

kingwithin

Offline

Joined: 12/10/2008

Yeah, let me check I don't have a change request from the developers....but at least I know what to ask now. Thank you.