phillip29

Thanks Tim – I download the new version and the error message above has gone. Still scratching my head though…

First I have used [mediacat cats=”Documents,Images” orderby=”date” order=”DESC”] in my search page and I just get a line of headings “Title File Name Caption Date”

I have also tried [mediacatform] and get the following error ” Warning: in_array() expects parameter 2 to be array, null given in /home/content/43/9857443/html/wp-content/plugins/media-category-library/views/search.php on line 10
> Fosternets”

I hope you can help

Philip

Thanks Tim

Can you post a link to the version that works?

Philip

I think it is wp_ for instance further down the text file is the entry “– Table structure for table wp_ai1ec_event_category_colors”

oh ok – I am getting any where?

Would it be possible for me to send you the original database dump to take a look at? it seems a bit weird that the extra stuff was in there.

Thanks Esmi I did that – now I get the following

Error
SQL query:

DATABASE : red1225804151029 —
CREATE DATABASE red1225804151029 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL said:

#1064 – 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 ‘Database: red1225804151029
CREATE DATABASE red1225804151029 DEFAULT CHARACTE’ at line 1

red1225804151029 being the name of the database I originally backed up. This is NOT the name of the database I am trying to upload to

Well I remove all the schema data – now I get the following message

Error
SQL query:

—————————————————— —
—
— Table structure for table INNODB_IO_PATTERN
—
CREATE TEMPORARY TABLE INNODB_IO_PATTERN (

SPACE BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
OFFSET BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
INDEX_ID BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
TABLE_NAME VARCHAR( 32 ) NOT NULL DEFAULT ”,
INDEX_NAME VARCHAR( 32 ) NOT NULL DEFAULT ”,
N_READ BIGINT( 11 ) NOT NULL DEFAULT ‘0’,
N_WRITE BIGINT( 11 ) NOT NULL DEFAULT ‘0’
) ENGINE = MEMORY DEFAULT CHARSET = utf8;

MySQL said:

#1064 – 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 ‘——————————————————–

—
— Table structure ‘ at line 1

which looks a bit nasty

Thanks esmi – I will do that now and try and import