Serendipity Forums

Mysql client server 4.1.9
Apache 2 hnadler
PHP 5.0.4
web site weweartights.org and earthly.biz (s9y blog sites)
These domains are administered by me

phpMyAdmin used for examing mysql database
database name wwt - weweartights.org
database name - earthly.biz

phpMyadmin can not can not display database "wwt" tables named "comments" and "link_category". There is some inconsistancy. Twice I was able to view all of "comments"with phpMyAdmin.

I can view all the tables in "mysql" supporting the domain earthly.biz

Before I simply erase the wwt database and start from the beginning with a new installation of sy9, I thought I would try to rebuild the table comments and link_category.
I've never done this before. I will use the table information available to me from the fully fuctional "mysql" database that supports my s9y:earthly.biz

If you can suggest a better way to recover or to go about fixing the tables or reinstalling s9y do please tell me.

If you check my most previous message thread you can review what has lead me up to considering to take this course of action

thank you

----edited------12:03 PM CST USA

I discovered some mysql tool "myisamchk" that checks the tables. To be run after flushing the tables with the mysqladmin command.

This tool indicates that "all" the tables in database "wwt" are error free !

[root@localhost wwt]# /usr/local/bin/mysqladmin flush-tables -p
Enter password:
[root@localhost wwt]# /usr/local/bin/myisamchk /usr/local/var/wwt/serendipity_*.MYI
Checking MyISAM file: /usr/local/var/wwt/serendipity_authors.MYI
Data records: 1 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_category.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_comments.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_config.MYI
Data records: 60 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_entries.MYI
Data records: 4 Deleted blocks: 1
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_entrycat.MYI
Data records: 4 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_entryproperties.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_exits.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_images.MYI
Data records: 1 Deleted blocks: 2
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_link_category.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_links.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_plugins.MYI
Data records: 14 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_references.MYI
Data records: 0 Deleted blocks: 1
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_referrers.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links

---------

Checking MyISAM file: /usr/local/var/wwt/serendipity_suppress.MYI
Data records: 6 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
[root@localhost wwt]#

The seems to tell me I can not reliably use myPHPAdmin to vew a mysql database
or
I need to find a tool that checks other database features

I can only repeat what I wrote on a different thread: Your server definitely has network/mysql traffic issues and problems!

If phpMyAdmin cannot reliably show the data, it means that your connection has problems, and the server itself is malfunctioning. You'll need to inspect your hardware, your ethernet devices, your cables and check for memory/CPU corruption on the server.

It sounds very much like hardware failure to me, most probably cables or network devices or memory.

Regards,
Garvin

You have me at a disadvantage becuse I'm not that familiar with mysql and or serendipity.

But I can pretty much say there is nothing wrong with the hardware.

I've run other blog engines without a problem. Those blog's used a flat file and did not require a database.

Curently one of my blog sites with your software is runing and to the best of my knowledge it running 100%.

I just tired reinstalling the second blog, after recreating the database and rebuilding the database from the beginning with a fresh install of serendipity. Much to my suprise I have the "same" problem. When I open logged in as administrator and select "configuration" the page doesn't load to completion.

The new installation added all the serendipity tables to the database during the installation.

Question: Does s9y support two domains on the same machine? If so is there only one way to do this? because what I do is create two seperate locations on the hard drive to install s9y. I take and copy all the files that get de-archived and store them in a directory with the name of the domain. In Apache I point to these two directories as "Virtual Domain" paths.

I note that in your documentation you have a entry called "Shared Installation"
and note that it is experimental. if i replace the term "user" with the term "domain" It looks like your "user" is in fact a "domain" yes/no ?

thank you

The reason is just that if even phpMyAdmin is having difficulties to connect to MySQL, you can see that Serendipity is not involved in this issue.

If you can exclude hardware failures, then you'll need to look for MySQL problems or other interfering software. Start looking at the /var/log/* files, mostly the syslog. You might also want to make a long-time ping of the mysql port/server and see if you have any network loss?

Did you check your server/apache errorlogfiles? Usually if a page does not fully load you must see some sigfaults / dying processes or PHP error message.

s9y can only support multiple domains if either installed multiple times, or using the shared installation you have already found. And yes, a "user" there is in fact a "domain", so you should be able to follow the installation instructions pretty easy.

My suggestion for you is to talk to a Server Administrator who can have a look at your MySQL and general HTTP connectivity issues as well as the error logs to spot where the problem lies. To me it looks like it's two things: One being MySQL network problems, the other being a PHP error which happens and does not show the full "configuration" page.

I can offer you to look at it and do some debugging, but I'd need FTP privileges to see why the configuration page fails on your server, as well as your login data to the s9y installation. Contact me privately, if you want to do that.

Regards,
Garvin

Contact me privately, if you want to do that

your email address is? or do you have another way in mind

You picked up on the fact that one of the s9y domains my "www.earthly.biz" site database seems to be fully functional ? MyPhpAdmin can open all the tables including the "comments"table in that blogs database but not the "comments table" generated by adding a second s9y supported database.

I'm not necessarily saying this has anything to do with s9y. I'm just looking for some perspective on what I'm experiencing in relation to s9y.

I'll try checking all the logs. Interpreting the logs is another story.

Maybe I'll try upgrading Mysql

thank you