Zikula Community

I was playing around with the blocks admin and implemented the Xanthia block to see what it would do, and it ended up causing an error message on my site that disallowed me from going anywhere! So, i search the forums and see the overwhelming response to this problem was to edit out the line in the prefix_blocks table in MySQL. I went ahead and dropped what I thought was the correct thing, but alas it was not. Now my site registers:
Fatal error: Call to a member function on a non-object in /home/slantmus/public_html/modules/Xanthia/pnuserapi.php on line 584
Am I screwed here? i see that i can upload single files to MySQL, but Im not exactly sure exactly what is was I dropped. Do i I have to just completely reupload the whole Blocks section? If so, how exactly would I go about doing that?
Any help or info would be greatly appreciated!

It sounds like you droped the whole blocks table and not just the offending row within the table.

Assuming you've done as you should and made a backup dump of your MySQL DB tables, you should proly just use that to get back to where you were.

However assumptions being what they are, if you don't have one then you may need to ask your host for a backup, they may even do it for you.

Also files are not physicaly changed when you add or remove blocks so re-uploading won't do anything for you... it's all in the DB.

--
Under Construction!

no, I didnt dump the entire blocks table, just one line of it. Though it was a part of the table, and not neccesarily a block, that I dropped. This is the area I was in:
Field Type Attributes Null Default Extra Action
pn_bid int(11) UNSIGNED No auto_increment
pn_bkey varchar(255) No
pn_title varchar(255) No
pn_url varchar(254) No
pn_mid int(11) UNSIGNED No 0
pn_position char(1) No l
pn_weight decimal(10,1) No 0.0
pn_active tinyint(3) UNSIGNED No 1
pn_refresh int(11) UNSIGNED No 0
pn_last_update timestamp(14) No
pn_language varchar(30) No
pn_collapsable int(11) No 1
pn_defaultstate int(11)
Which I now realize wasn't even the right area to be in! Ive now correctly dumped the offending line, but I still have to reinsert what i dropped, which I cant recall the title of, only that it was the only thing with a Type of "Text". I do not have a DB backup (but now having gone through this, I will do so the moment I get this fixed).
So, Ive contacted my host for a backup, but is there any other way to reinsert what Ive dumped? Can I just reupload the pnuserapi.php in my host admin, or would I have to readd the file directly into MySQL?
Obviously I am an idiot, and would love any direction possible! Thanks....