Well I had it working

0 views
Skip to first unread message

edwardiglesias

unread,
May 2, 2008, 11:23:28 AM5/2/08
to Scriblio
I had a server issue and had to reinstall everything. Now I am
getting a new issue. Only 3 records attempt to load and then the
process stops

Reading the file and parsing 336 records. Please be patient.

1. The Children Of Noisy Village ii
2. Wishbone: Salty Dog ii
3. The Prime Of Miss Jean Brodie ii

I am using the example set and have tried this with the latest svn as
well as with the 2.3 version of wordpress with exactly the same
results. I've tried both

[852][0]->subfields['p']

['001'][0]->data

and both seem to find the file just fine but then get stuck. The
upload file shows

[root@localhost 05]# ls -l
total 356
-rw-rw-rw- 1 apache apache 359901 May 2 11:07 10132007mrc
[root@localhost 05]#


Mysql seems populated

Database changed
mysql> show tables;
+-----------------------+
| Tables_in_scriblio |
+-----------------------+
| wp_bsuite3_hits |
| wp_bsuite3_refs_terms |
| wp_bsuite3_search |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_scrib_harvest |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_terms |
| wp_usermeta |
| wp_users |
+-----------------------+
14 rows in set (0.00 sec)

mysql>
mysql> select *.mrc from wp_posts;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '.mrc from wp_posts' at line 1
mysql> select * from wp_posts;
+----+-------------+---------------------+---------------------
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------+---------------+--------------------+-------------
+----------------+-------------+---------------+---------------
+---------+--------+---------------------+---------------------
+-----------------------+-------------
+-----------------------------------------------------------------------
+------------+------------+----------------+---------------+
| ID | post_author | post_date | post_date_gmt |
post_content
| post_title | post_category | post_excerpt | post_status |
comment_status | ping_status | post_password | post_name | to_ping
| pinged | post_modified | post_modified_gmt |
post_content_filtered | post_parent |
guid
| menu_order | post_type | post_mime_type | comment_count |
+----+-------------+---------------------+---------------------
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------+---------------+--------------------+-------------
+----------------+-------------+---------------+---------------
+---------+--------+---------------------+---------------------
+-----------------------+-------------
+-----------------------------------------------------------------------
+------------+------------+----------------+---------------+
| 1 | 1 | 2008-05-02 10:59:52 | 2008-05-02 14:59:52 |
Welcome to WordPress. This is your first post. Edit or delete it, then
start
blogging!
| Hello world! | 0 | | publish |
open | open | | hello-world |
| | 2008-05-02 10:59:52 | 2008-05-02 14:59:52
| | 0 | http://149.152.27.99/wordpress/?p=1
| 0 | post | | 1 |
| 2 | 1 | 2008-05-02 10:59:52 | 2008-05-02 14:59:52 | This
is an example of a WordPress page, you could edit this to put
information about yourself or your site so readers know where you are
coming from. You can create as many pages like this one or sub-pages
as you like and manage all of your content inside of WordPress. |
About | 0 | | publish |
open | open | | about |
| | 2008-05-02 10:59:52 | 2008-05-02 14:59:52
| | 0
|
| 0 | page | | 0 |
| 3 | 1 | 2008-05-02 11:02:11 | 2008-05-02 15:02:11 |
Browse new
titles.
| Browse | 0 | Browse new titles. | publish |
open | open | | browse |
| | 2008-05-02 11:02:11 | 2008-05-02 15:02:11
| | 0 | http://149.152.27.99/wordpress/?page_id=3
| 0 | page | | 0 |
| 4 | 1 | 2008-05-02 11:04:12 | 2008-05-02 15:04:12 |
http://149.152.27.99/wordpress/wp-content/uploads/2008/05/10132007mrc
| 10132007mrc | 0 | | inherit |
open | open | | 10132007mrc |
| | 2008-05-02 11:04:12 | 2008-05-02 15:04:12
| | 0 |
http://149.152.27.99/wordpress/wp-content/uploads/2008/05/10132007mrc
| 0 | attachment | | 0 |
| 5 | 1 | 2008-05-02 11:07:50 | 2008-05-02 15:07:50 |
http://149.152.27.99/wordpress/wp-content/uploads/2008/05/10132007mrc
| 10132007mrc | 0 | | inherit |
open | open | | 10132007mrc-2 |
| | 2008-05-02 11:07:50 | 2008-05-02 15:07:50
| | 0 |
http://149.152.27.99/wordpress/wp-content/uploads/2008/05/10132007mrc
| 0 | attachment | | 0 |
+----+-------------+---------------------+---------------------
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+--------------+---------------+--------------------+-------------
+----------------+-------------+---------------+---------------
+---------+--------+---------------------+---------------------
+-----------------------+-------------
+-----------------------------------------------------------------------
+------------+------------+----------------+---------------+
5 rows in set (0.00 sec)

Any ideas would be appreciated.
Reply all
Reply to author
Forward
0 new messages