Loading...
 
Features / Usability

Features / Usability


is this a mysql or tikiwiki issue?

posts: 37 United States

I just moved our 3 live tikiwiki sites to a new server, copying the file system and mysql db verbatim. I updated user/pass for mysql in the config for tikiwiki and it was able to successfully hook up with the db on each site. The problem is that this error is now the only thing that will come up at the sites:cry

Warning: mysql error: Table 'tiki_sessions' is read only in query:
insert into `tiki_sessions`(`sessionId`,`timestamp`,`user`) values(?,?,?)
in /home/rtd69/public_html/tiki3/lib/tikidblib.php on line 133

Fatal error: Call to a member function on a non-object in /home/rtd69/public_html/tiki3/lib/tikidblib.php on line 151

I have been looking ALL over and can't figure out what solves this kind of thing in mysql. If anyone knows anything about this error, please give me some clues so I can fix it. Currently all 3 sites are down and I just don't understand the error enough to fix it (I'm not a mysql pro but I think it's a mysql problem). I'm posting here in case it is something in tikiwiki though I need to fix. Just knowing it *isn't* probably a tiki issue would help me out.

Thanks!

Kelly

posts: 32 United Kingdom


It would seem that the MySQL user which tikiwiki is logging into the MySQL server as, doesn't have the correct privileges. Have you granted all privileges to the tiki user? Does it work if you test putting the MySQL root user/password in db/local.php? :-)

...Just thinking out loud.

Regards,
Gray


posts: 32 United States
How firm is the 'not working' statement? I have been running 1.9rc3 with MySQL 4.1.9 for almost 2 months with no data issues. Granted, I am not using all modules, but I am using the major ones?
posts: 32 United States
Ah well, I plan to port to SQLServer anyhow, so no biggie.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting