+ Post New Thread
Results 1 to 8 of 8
Web Development Thread, PHP Error?? Help Urgent in Coding and Web Development; Hi all. Here at the school we host a few sites and one of which runs using Apache and PHPMyAdmin. ...
  1. #1
    deccy's Avatar
    Join Date
    Jun 2010
    Posts
    14
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    PHP Error?? Help Urgent

    Hi all.

    Here at the school we host a few sites and one of which runs using Apache and PHPMyAdmin. For some reason the following message has appeared and we dont know why.

    jtablesession::Store Failed
    DB function failed with error number 1054
    Unknown column 'client_id' in 'field list' SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`clie nt_id` ) VALUES ( 'f262b7dd736b310fd841351c1946a69f','1278519931','' ,'0','1','0' )

    (http://www.kidsgrovescouts.com)

    This is running on Joomla 1.0.

    We have not had a problem with this before and i have read a few forums and still, the problem continues. My knowledge is very little to non when it comes to PHP so any help or solutions on this matter will be greatly welcomed!!!

    Cheers.

  2. #2
    deccy's Avatar
    Join Date
    Jun 2010
    Posts
    14
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    How would i change that so there is no space? As i said, my knowledge is not good with PHP and PHPMyadmin

  3. #3

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,658
    Thank Post
    858
    Thanked 646 Times in 429 Posts
    Rep Power
    498
    have you got access to phpmyadmin soyou can check the MySQL Database in question and make sure that the "client_id" column exists?

    Edit your pos and remove the space...

  4. #4
    deccy's Avatar
    Join Date
    Jun 2010
    Posts
    14
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I do have access to the PHPMYadmin. I can see a "Session_ID" but no "Client_ID" column.

  5. #5
    deccy's Avatar
    Join Date
    Jun 2010
    Posts
    14
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    the session ID is also Underlined for some reason. Is this normal or is it telling me that it is that field that is the proplem.

    Ive clicked Edit and this is what it says

    ALTER TABLE `jos_session` CHANGE `client_id` `client_ID` VARCHAR(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0'
    Last edited by deccy; 7th July 2010 at 05:45 PM.

  6. #6
    deccy's Avatar
    Join Date
    Jun 2010
    Posts
    14
    Thank Post
    2
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    here is a screen shot of my tables "jos_session"
    Attached Images Attached Images

  7. #7
    SneakyBeaky's Avatar
    Join Date
    May 2010
    Location
    Gosport
    Posts
    141
    Thank Post
    7
    Thanked 22 Times in 19 Posts
    Rep Power
    15
    Have you by any chance just changed to a new version of MYSQL? or PHP?
    This sort of error first surfaced when MySQL4.1 was changed to MySQL 5 and the syntax was changed.
    Try updating your version of Joomla which may have a fix for the problem.
    Last edited by SneakyBeaky; 7th July 2010 at 06:20 PM. Reason: spelling fixed

  8. #8

    Join Date
    Oct 2008
    Location
    Gosport
    Posts
    64
    Thank Post
    1
    Thanked 18 Times in 13 Posts
    Rep Power
    15
    My 2pence:
    * None of the column names is underlined: the "session_id" and "client_id" column names have an underscore in them instead of a space because you aren't allowed to have spaces in column names.
    * Column names are not generally case sensitive ("client_id" is the same as "client_ID") but it couldn't hurt to make sure that the column names listed in phpmyadmin look the same as the columns listed in that error message.
    * If not all the columns listed in that error are present in the jos_session table when you look in phpmyadmin then you could try to modify the table has them
    * If you've still got your original download of Joomla 1.0 you may be able to look in the installation folder then sql then joomla.sql and find the structure for the jos_session table. If you find that you could drop the existing table and re-run the query from your original installation and see if that puts things back to how they should be (nothing of permanent importance is in jos_session, so this should be pretty safe... but you should always backup before doing anything that might cause harm)
    * I'd guess this could only have happened if you've changed something on the server or maybe installed a new component/module. Maybe you accidentally (somehow) installed a 1.5 component and it altered the database structure?
    * Maybe this is your server's way of telling you it wants you to upgrade to Joomla 1.5 and perhaps you should take the hint?

    Sorry I can't offer a more concrete solution, but hopefully this gives you some directions to explore.

SHARE:
+ Post New Thread

Similar Threads

  1. RAID error - help / urgent
    By morganw in forum Hardware
    Replies: 5
    Last Post: 11th June 2010, 09:13 AM
  2. MRBS, PHP, IIS 6.0, and one 500 error
    By mossj in forum Web Development
    Replies: 7
    Last Post: 14th July 2009, 04:23 PM
  3. Configuration.php error?
    By Dafty in forum EduGeek Joomla 1.5 Package
    Replies: 5
    Last Post: 18th March 2009, 01:56 PM
  4. PHP error on Manual WAMP setup
    By Nij.UK in forum Web Development
    Replies: 5
    Last Post: 28th March 2007, 09:47 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •