Fork me on GitHub

.763 to .764 module question  Bottom

  • I had a module designed for me in the past that worked perfectly in .763. Here recently, I upgraded to .764 and I get the "Error! Sorry! Table creatin failed".

    Exact error after attempting to initialize module:

    Quote

    Error! Sorry! Table creation failed CREATE TABLE IF NOT EXISTS pn_venues_reviews ( pn_venues_reviews.review_id int(11) NOT NULL auto_increment, pn_venues_reviews.review_venid int(11) NOT NULL default 0, pn_venues_reviews.review_uid int(11) NOT NULL default 0, pn_venues_reviews.review_name varchar(100) NOT NULL default '', pn_venues_reviews.review_email varchar(100) NOT NULL default '', pn_venues_reviews.review text NOT NULL default '', pn_venues_reviews.review_status int(1) NOT NULL default 0, pn_venues_reviews.review_date datetime NOT NULL, PRIMARY KEY (review_id), KEY `review_venid` (`review_venid`), KEY `review_isfirst` (`review_isfirst`))


    I was curious if there were any changes made from .763 to .764 that could be causing this issue? All the other modules I had initialized fine without a hitch.

    Any input would be greatly apprciated.

    Thanks for your time!
  • Perhaps some buggy code in the upgrade functions.
  • By this do you mean that the PN upgrade process was buggy? If so, I should clarify.

    I went from .763 to .764 by means of fresh install and transferred all my modules over. I also enabled legacy support.

    Thanks for your reply!
  • Ok, well.. after sifting through pinit.php and having very little knowledge of PHP and SQL, I finally found the error in case this happens to anyone else (which is doubtful, my module was created sloppy it seems).

    Quote

    KEY `review_isfirst` (`review_isfirst`))

    The code is asking to make a field, that doesn't exist, a KEY index.

    Thats my take on it anyways, I removed the above line and the module initialized. I guess .763 allowed this to happen because I checked my backups and this line has always been there.

This list is based on users active over the last 60 minutes.