there was no errors in the upgrade. however the reason why everything disapeared was because there was a corrupted table I used tools.php and fixed that.

I will manually add the templates but the SQL error what would that be from?

if you did not receive errors you can rebuild the styles through admincp and hopefully the templates will update.

i think it may be caused by the space between ON and '('. im currently tinkering with beta 2 so once im done adding the features to beta 2 ill go and see if removing the spaces does anything.

could it be because your 3.0.7 and this was on 3.0.3?

Ok for this site how do I go about reverting? I want them to at least have thier old journals back.

looking at the database changes, you can just use the old file and templates and it should work;)

No for real... because I had that hack for vbjournal & vbinex and it only shows ,,,,, now. That was not changed at all so reverting templates will work? Im asking because you havent told me any thing about the errors I asked and I simply want them to have back thier journals if this doenst work.

the mysql error you said you got from journal.php may be due to a space between some components in the query and the way your server is processing the query. i think the editor and unupdated templates is due to the styles not rebuilding correctly. which if is the case, then in admincp you can go to Important & Maintenance -> Update Counters -> Rebuild Styles

Can users have several journals for travel etc?

currently the system only allows one journal per user

thanks for the info. Shame it doesnt work for me.

dont have time to look into this in great detail myself but i need to be able to stop administrators being able to read peoples or just other administrators private journals / entries . One admin read another admins journals private entries...caused mass havoc...:s would be nice to be able to set it so admins can't read things set private to other admins.
:surprised: