Thanks Bananadude.

I mean, I have updated the System module, and deleted and readded the Who's online block, but in my databases the table doesn't exist. Is there a way to get the table back?

As for debug messages TONS! eek!

I get the:
Notice: Only variable references should be returned by reference in /home/myname/public_html/kernel/module.php on line 172

at the top of the page.

plus over 50 seperate ones such as:

Notice: Only variables should be assigned by reference in /home/myname/public_html/modules/piCal/include/read_configs.php on line 64

Notice: Only variable references should be returned by reference in /home/myname/public_html/modules/xoopspoll/class/xoopspoll.php on line 147

Notice: Only variable references should be returned by reference in /home/myname/public_html/modules/xoopspoll/class/xoopspolloption.php on line 118

Notice: Only variable references should be returned by reference in /home/myname/public_html/modules/xoopspoll/class/xoopspolloption.php on line 118

Notice: Only variables should be assigned by reference in /home/myname/public_html/modules/piCal/include/read_configs.php on line 64

Notice: Only variables should be assigned by reference in /home/myname/public_html/class/module.textsanitizer.php on line 312

Notice: Only variables should be assigned by reference in /home/myname/public_html/class/module.textsanitizer.php on line 313


OMG

Those notices are no problem. Try this to get your block back:

Re download a new copy of the version of XOOPS you are using. After unzipping it on your local computer, go into the modules directory, upload the system module to the modules directory on your server. Update the system module in Modules - Administration.

Aww man.... I thought this would work. No good.

Whoever can work this one out is a genius.

:(

Thanks for your help guys. This girl's hair might be turning white. :)

It will be solved sooner or later

Have you tried with MySQL debug? Check if you get any errors.

Best Regards,
Bananadude

Thanks for hanging in there with me. :)

I fee; a bit cheeky as there's others with worse troubles. At least my site is working. But hopefully this might help in other block disappearing issues.

I tried sql debug and got a few, but these seem relevant:

--------------------
SELECT COUNT(*) FROM xoopstable_online WHERE online_uid=1
Error number: 1146
Error message: Table 'myname_xoops1.xoopstable_online' doesn't exist
( 0.000333)
INSERT INTO xoopstable_online (online_uid, online_uname, online_updated, online_ip, online_module) VALUES (1, 'Mon', 1134675970, '62.254.0.18', 1)
Error number: 1146
Error message: Table 'myname_xoops1.xoopstable_online' doesn't exist
( 0.000175)
SELECT * FROM xoopstable_online
Error number: 1146
Error message: Table 'myname_xoops1.xoopstable_online' doesn't exist
( 0.000135)
----------------------

I guess it's telling me the table doesn't exist, which we already know.

tia :)

well, when we solve this problem then we maybe motivate you to help other users with similar or other problems. So in the theory, then every question is important

First, make a backup of your database!

You need to create the missing table, if you use phpMyAdmin you can do it like this: Click query window (small "SQL" icon in the left menu), select your XOOPS database fom the dropdown.

Copy and paste this into the query window:



XXXX have to be replaced with your prefix, if your prefix is 87dha0 then it will be 87dha0_online

CHARSET=latin1; should be replaced with the character set you use, if you are unsure on what to write there you can open the backup of your database in Notepad and see the buttom of each table-creation (if you can't read your sql-file because it's messy, then drag and drop it to your browser)

Press Go and your table should be created sucessfully, and hopefully is the problem fixed

Databases isn't my very strongest side, so I hope you made a backup first and someone can validate what I wrote.
I'm not sure, but I think "DEFAULT CHARSET=utf8;" could be left out and that it might should be a "PRIMARY KEY (`online_uid`)," right above "KEY"

Best Regards,
Bananadude

Good grief, newbie hell. lol

This has certianly been a learning experience, I didn't even know how to do a backup.

OK, one notable difference with my sqls is that the end is:
TYPE=MyISAM AUTO_INCREMENT=4 ; or some other number

I couldn't find any table that mentioned charset or ENGINE.


I took the plunge and made adjustments. But of course, as I haven't a clue to what I'm doing, god knows what I've done. Ah, well, I've backed up. :)

This is what I used:



There it is!!!!!!! YIPPEE!!

I just knew I needed to get a table back, seemed logical.

You are the MAN! Go Bananadude!!!!

Although if you or anyone wants to suggest I tweak that code, by all means do. I don't want to have messed up sth else!

YEEEEEEEEAH! lol

x

hehe lol, thanx!

Well, as long as it works and makes you happy I think the code is correct, or at least close to it.

- Bananadude