TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

May 05, 2024, 07:10:58 PM

Login with username, password and session length
Members
  • Total Members: 3,885
  • Latest: Growner
Stats
  • Total Posts: 195,178
  • Total Topics: 21,220
  • Online today: 274
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 1
  • Guests: 258
  • Total: 259
  • @rjen

MySQL and 'Table error' with manual_tp_install_0971.php

Started by 3nd3r, January 23, 2007, 09:28:51 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

3nd3r

Lot of work... I've tried and after the install successful
    * Upshrink table created
    * Settings table exists
          o Updated version to 097
    * Blocks table created.
          o some sample values were added to the blocks table
    * Variables table created.
          o some sample values were added to the variables table
    * Articles table created.
          o some sample values were added to the articles table
    * DL manager table created

TinyPortalÃ,´s table structure is now installed/updated.
Thank you for trying out TinyPortal.

This is the result when I go to index.php:Warning: main(/home/pajareon/public_html/Sources/QueryString.php) [function.main]: failed to open stream: No such file or directory in /home/pajareon/public_html/index.php on line 49

Fatal error: main() [function.require]: Failed opening required '/home/pajareon/public_html/Sources/QueryString.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/pajareon/public_html/index.php on line 49

I attach you the index.php file...

Help please!

3nd3r

I CANNOT BACK TO MY ORIGINAL FORUM!!

MY WEB IS UNOPERATIVE!

HELP PLEASE!!  :'( :'(

3nd3r

Uploaded files needed.

This is the actual error:Table 'pajareon_smf.smf_tp_articles' doesn't exist

Can anybody give the SQL code to manually make the tables, please?

akulion

man its not suposed to be this complicated

i dont know what ur doing but either ways this is the query


CREATE TABLE IF NOT EXISTS `smf_tp_articles` (
  `id` int(11) NOT NULL auto_increment,
  `date` int(11) NOT NULL default '0',
  `body` longtext NOT NULL,
  `intro` text NOT NULL,
  `useintro` tinyint(4) NOT NULL default '1',
  `category` smallint(6) NOT NULL default '0',
  `frontpage` tinyint(4) NOT NULL default '1',
  `subject` text NOT NULL,
  `authorID` int(11) NOT NULL default '0',
  `author` text NOT NULL,
  `frame` tinytext NOT NULL,
  `approved` tinyint default '1' NOT NULL,
  `off` tinyint default '0' NOT NULL,
  `options` text NOT NULL,
  `parse` tinyint default '0' NOT NULL,
  `comments` tinyint default '0' NOT NULL,
  `comments_var` text NOT NULL,
  `views` int NOT NULL,
  `rating` text NOT NULL,
  `voters` text NOT NULL,
  `ID_THEME` smallint(6) default '0' NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=2;

3nd3r

Yes... There's anything wrong in any place... I do look for it

Thank you for your patience and support. (I need a holidays away from work... I know, I know, I KNOW!  :uglystupid2:O0

Is this the last table I need to create?

3nd3r

I think I get the error... There isn't an user created for my SQL database  :buck2:

So, I've created an user with all privileges, updated settings.php... And everything seems to be ok

And I'll try once again...  :buck2:

The only thing is that I've a lot of files in my site... backup files from uncompleted installs of TP...

So, I'm wondering to backup database and clean reinstall SMF + TP + Language files + Alienation Theme...

Hard work... So, what do you think? It's better try to backup and begin cleaned than trying once again installing manually TP?

If you choose the clean reinstall, can you tell me or forward me to a thread that explain this process?

Thank you again for your time, and I apologize for all inconveniences  :P

akulion

u dont have a user created for ur database?

Then how did u install SMF :P

you dont need to create any users to instal TP

If you smf is working, then it is simply a matter of uploading TP via package manager on a fresh SMF forum and install it via package manager

I would recommend if your database isnt too huge then u simply do a reinstall of SMF and start afresh

but if your database is huge then you can try salvaging it from the backup you may have available

3nd3r

Quote from: Aku on February 02, 2007, 11:48:59 AM
u dont have a user created for ur database?

Then how did u install SMF :P
Don't know... I did with cpanel password and it works...

Quote from: Aku on February 02, 2007, 11:48:59 AMIf you smf is working, then it is simply a matter of uploading TP via package manager on a fresh SMF forum and install it via package manager
Ok. I'll try again an automatic update...

Quote from: Aku on February 02, 2007, 11:48:59 AMI would recommend if your database isnt too huge then u simply do a reinstall of SMF and start afresh

but if your database is huge then you can try salvaging it from the backup you may have available
So, this is like a manual install, isn't it? So, if I simply delete all and upload SMF files ... It should work?

akulion

Restoring the database you have to do that via PHPMYadmin by importing an existing SLQ file

As for site restoration that just requires files and for the paths to be fixed using repair.settings.php

I would help u out with this but Ive got food poisioning today so I am feeling pretty darn horrible right now - but once Im a bit better probably by tomorrow or day after i could have a look

just make sure u keep ur db backup in a safe place

3nd3r

Ok man.

Restore yourself :up:, remember do a 'backup' of your stomach, even if you have to do 'manually' :-X, and make a 'clean' reinstall of your 'hardware'  ;)

I will post my experience with all that stuff

Get better!  :up: