problem reading from SQL DB?

[lajbans]

Hi
All out of sudden serendipity has problems reading the entries in my sql table.

When I check the serendipity_entries in mysql it adds new entries and all my old entires are there, thus they are not published on my frontpage nor to be seen in adminpage when check edit entries etc.

Last think I added was media, i tried to delete that entry manually from the sql table in hope that it was that causing the problem.
With no luck im stuck now, index.php is blank just saying "No entries to print"
and in adminmode no entries to be found...

[garvinhicking]

Hi!

So when you use phpMyAdmin to access the database you still see all entries?

Or is the table marked as crashed?

When you write a new entry, it also doesn't show up?

Could it be you installed a plugin or so? The media database can't be responsible.

Regards,
Garvin

[lajbans]

Hi don't have phpmyadmin doing all by shell command

mysql> CHECK TABLE serendipity_entries;
+--------------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+--------------------------------+-------+----------+----------+
| DB.serendipity_entries | check | status | OK |
+--------------------------------+-------+----------+----------+
1 row in set (0.05 sec)


No plugin installed either, it just disapeared by it self when I added a new entry with media in it.

pressed media button, inserted the image then volah its gone.

If I write a new entry - it shows up in DB.serendipity_entries with ID etc, but not on frontpage nor in admin page under edit entries.

could it be some persmission that got lost?

Is it some way I can check logs or get it to run in debug mode?

[garvinhicking]

Hi!

Most likely it's a permissions thing, yes.

Can you show the output of these queries:

Code: Select all

SELECT * FROM serendipity_entries ORDER BY id DESC LIMIT 1

and

Code: Select all

SELECT * FROM serendipity_authors;

(Strip your password!)

and

Code: Select all

SELECT * FROM serendipity_entryproperties WHERE entryid = YOUR-LATEST-ENTRYID;

(Insert the id of the entry that is missing here)

and

Code: Select all

SELECT * FROM serendipity_entrycat WHERE entryid = YOUR-LATEST-ENTRYID;

and

Code: Select all

SELECT * FROM serendipity_access WHERE artifact_type = 'category' AND artifact_id = YOUR-CATEGORY-ID

(Replace YOUR-CATEGORY-ID with the ID of the category that your entry was assigned to in the serendipity_entrycat table)

Depending on that output I might need to also see your related output in the serendipity_groups and serendipity_groupconfig table.

I think that it might be related to your author not being in a usergroup that is allowed to read entries, or that a category was created with read/write privileges that do not include your authorgroup.

Regards,
Garvin

[lajbans]

Here it all comes, as you see I dont use cat's for my entries and no group assigned to my user more than admin

Code: Select all

mysql> SELECT * FROM serendipity_entries ORDER BY id DESC LIMIT 1
    -> ;
+----+-------+------------+---------+----------+------------+----------+--------+--------+----------+---------+----------------+---------------+-------------------+
| id | title | timestamp  | body    | comments | trackbacks | extended | exflag | author | authorid | isdraft | allow_comments | last_modified | moderate_comments |
+----+-------+------------+---------+----------+------------+----------+--------+--------+----------+---------+----------------+---------------+-------------------+
| 33 | test  | 1188983571 | asdasda |        0 |          0 |          |      0 | tadde  |        1 | false   | true           |    1188983571 | false             |
+----+-------+------------+---------+----------+------------+----------+--------+--------+----------+---------+----------------+---------------+-------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM serendipity_authors;
+----------+----------+----------------------------------+----------+---------------+-----------------+---------------+-----------+---------------+
| realname | username | password                         | authorid | mail_comments | mail_trackbacks | email         | userlevel | right_publish |
+----------+----------+----------------------------------+----------+---------------+-----------------+---------------+-----------+---------------+
| removed  | removed  | removed                          |        1 |             0 |               0 | echo@swip.net |       255 |             1 |
+----------+----------+----------------------------------+----------+---------------+-----------------+---------------+-----------+---------------+
1 row in set (0.00 sec)


mysql> SELECT * FROM serendipity_entryproperties WHERE entryid = 33;
Empty set (0.00 sec)

mysql> SELECT * FROM serendipity_entrycat WHERE entryid = 33;
Empty set (0.00 sec)

mysql> SELECT * FROM serendipity_access WHERE artifact_type = 'category' AND artifact_id = 0;
Empty set (0.01 sec)

mysql> select * from serendipity_groups;
+----+-----------------------+
| id | name                  |
+----+-----------------------+
|  1 | USERLEVEL_EDITOR_DESC |
|  2 | USERLEVEL_CHIEF_DESC  |
|  3 | USERLEVEL_ADMIN_DESC  |
+----+-----------------------+
3 rows in set (0.02 sec)

mysql> select * from serendipity_groupconfig;
+----+-----------------------------------+-------+
| id | property                          | value |
+----+-----------------------------------+-------+
|  1 | userlevel                         | 0     |
|  1 | personalConfiguration             | true  |
|  1 | personalConfigurationUserlevel    | false |
|  1 | personalConfigurationNoCreate     | false |
|  1 | personalConfigurationRightPublish | false |
|  1 | siteConfiguration                 | false |
|  1 | blogConfiguration                 | false |
|  1 | adminEntries                      | true  |
|  1 | adminEntriesMaintainOthers        | false |
|  1 | adminImport                       | false |
|  1 | adminCategories                   | true  |
|  1 | adminCategoriesMaintainOthers     | false |
|  1 | adminCategoriesDelete             | false |
|  1 | adminUsers                        | false |
|  1 | adminUsersDelete                  | false |
|  1 | adminUsersEditUserlevel           | false |
|  1 | adminUsersMaintainSame            | false |
|  1 | adminUsersMaintainOthers          | false |
|  1 | adminUsersCreateNew               | false |
|  1 | adminUsersGroups                  | false |
|  1 | adminPlugins                      | false |
|  1 | adminPluginsMaintainOthers        | false |
|  1 | adminImages                       | true  |
|  1 | adminImagesDirectories            | false |
|  1 | adminImagesAdd                    | true  |
|  1 | adminImagesDelete                 | true  |
|  1 | adminImagesMaintainOthers         | false |
|  1 | adminImagesViewOthers             | true  |
|  1 | adminImagesView                   | true  |
|  1 | adminImagesSync                   | false |
|  1 | adminComments                     | false |
|  1 | adminTemplates                    | false |
|  2 | userlevel                         | 1     |
|  2 | personalConfiguration             | true  |
|  2 | personalConfigurationUserlevel    | true  |
|  2 | personalConfigurationNoCreate     | true  |
|  2 | personalConfigurationRightPublish | true  |
|  2 | siteConfiguration                 | false |
|  2 | blogConfiguration                 | true  |
|  2 | adminEntries                      | true  |
|  2 | adminEntriesMaintainOthers        | true  |
|  2 | adminImport                       | true  |
|  2 | adminCategories                   | true  |
|  2 | adminCategoriesMaintainOthers     | true  |
|  2 | adminCategoriesDelete             | true  |
|  2 | adminUsers                        | true  |
|  2 | adminUsersDelete                  | true  |
|  2 | adminUsersEditUserlevel           | true  |
|  2 | adminUsersMaintainSame            | true  |
|  2 | adminUsersMaintainOthers          | false |
|  2 | adminUsersCreateNew               | true  |
|  2 | adminUsersGroups                  | true  |
|  2 | adminPlugins                      | true  |
|  2 | adminPluginsMaintainOthers        | false |
|  2 | adminImages                       | true  |
|  2 | adminImagesDirectories            | true  |
|  2 | adminImagesAdd                    | true  |
|  2 | adminImagesDelete                 | true  |
|  2 | adminImagesMaintainOthers         | true  |
|  2 | adminImagesViewOthers             | true  |
|  2 | adminImagesView                   | true  |
|  2 | adminImagesSync                   | true  |
|  2 | adminComments                     | true  |
|  2 | adminTemplates                    | true  |
|  3 | userlevel                         | 255   |
|  3 | personalConfiguration             | true  |
|  3 | personalConfigurationUserlevel    | true  |
|  3 | personalConfigurationNoCreate     | true  |
|  3 | personalConfigurationRightPublish | true  |
|  3 | siteConfiguration                 | true  |
|  3 | blogConfiguration                 | true  |
|  3 | adminEntries                      | true  |
|  3 | adminEntriesMaintainOthers        | true  |
|  3 | adminImport                       | true  |
|  3 | adminCategories                   | true  |
|  3 | adminCategoriesMaintainOthers     | true  |
|  3 | adminCategoriesDelete             | true  |
|  3 | adminUsers                        | true  |
|  3 | adminUsersDelete                  | true  |
|  3 | adminUsersEditUserlevel           | true  |
|  3 | adminUsersMaintainSame            | true  |
|  3 | adminUsersMaintainOthers          | true  |
|  3 | adminUsersCreateNew               | true  |
|  3 | adminUsersGroups                  | true  |
|  3 | adminPlugins                      | true  |
|  3 | adminPluginsMaintainOthers        | true  |
|  3 | adminImages                       | true  |
|  3 | adminImagesDirectories            | true  |
|  3 | adminImagesAdd                    | true  |
|  3 | adminImagesDelete                 | true  |
|  3 | adminImagesMaintainOthers         | true  |
|  3 | adminImagesViewOthers             | true  |
|  3 | adminImagesView                   | true  |
|  3 | adminImagesSync                   | true  |
|  3 | adminComments                     | true  |
|  3 | adminTemplates                    | true  |
+----+-----------------------------------+-------+
96 rows in set (0.01 sec)

Thanks for all your help so far, hope this brings out some solution

/A

[lajbans]

Got some new errors now....

Code: Select all

Warning: mysql_connect() [function.mysql-connect]: Access denied for user: 'tadde@localhost' (Using password: YES) in /home/nb/include/db/mysql.inc.php on line 270

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user: 'apache@localhost' (Using password: NO) in /home/nb/include/db/mysql.inc.php on line 271

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /home/nb/include/db/mysql.inc.php on line 271

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/nb/include/db/mysql.inc.php on line 281

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/nb/include/db/mysql.inc.php on line 281
serendipity error: unable to connect to database - exiting.

[garvinhicking]

Hi!

Okay, I can tell now that your database tables are properly configured.

The error you get now comes from your MySQL server, it rejects your username and password. Did you change your credentials, or did the server admin change anything?

As for the entries not showing up, can you tell me your URL? And which event plugins do you have installed?

Never seen this before yet. I would guess a database error, but because the "CHECK TABLE" command returns no errors, this is strange. Inserting a media image only inserts a record into "serendipity_images" DB table and should not in any way tamper with entry data...

I could offer to give a look at the installation if you're able to provide me with temporary FTP accesS? If you want that, please contact me privately.

Best regards,
Garvin

[lajbans]

Hi,
Thanks for your help.
I solved it the easiest way - exporting the entries and then re-install s9 and import entries.

Works like a charm now.

Thanks for your help!