|
|
 |
 | Fatal Error In Upgrade! |  |
 Posted: Sat Jan 31, 2004 2:59 am |
 |
|
|
Hi,
I just performed the version 2.4 upgrade. After I ran the upgrade.php file in my browser, I was told that the upgrade was successful. But when I access the site I get this message:
Warning: main(D:\Apache\htdocs\Randomizer/lib/stdlib.php): failed to open stream: No such file or directory in /home/cashrand/public_html/config.php on line 173
Fatal error: main(): Failed opening required 'D:\Apache\htdocs\Randomizer/lib/stdlib.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/cashrand/public_html/config.php on line 173
What happened?
Thanks. |
|
|
|
|
| | |
| Posted: Sat Jan 31, 2004 7:35 pm |
|
|
| shadow |
| Addict |
|
|
| Joined: 16 Oct 2003 |
| Posts: 171 |
| Location: Virgin Islands |
|
|
|
|
 |
|
It looks like you are running two different servers at the same time. If you are using a windows server your config will start with something like D:\
If you are running a linux server then it will usually start with something like /home/username but you will never see both. Check your config.php file and set it for which ever server you are using.
Shadow |
|
|
|
|
| Posted: Sat Jan 31, 2004 9:30 pm |
|
|
|
Hi Shadow,
Thank you very much for your response. I realized the error and corrected it thanks to your help.
But now I have another problem. Now when I try to access my site I get this message:
Warning!
The following error occured:
MySQL Error: Table 'cashrand_randomize.textads' doesn't exist
The script is now halted.Please contact the webmaster
Do I need to create another mysql table? Any help is appreciated!
Thanks!
By the way my site is http://www.cash-random.com. |
|
|
|
|
| | |
| Posted: Sun Feb 01, 2004 12:42 pm |
|
|
| shadow |
| Addict |
|
|
| Joined: 16 Oct 2003 |
| Posts: 171 |
| Location: Virgin Islands |
|
|
|
|
|
|
Yes it looks like you are missing the textads table and I would presume that you are missing the banners table also. These are all added to the database with upgrade files. If you have an earlier file called upgrade.php (not the one with the 2.4 upgrade) run it and it will install the table and fields you need. You can also create them from phpMyadmin or from shell access. But the the biggest question is what version are you upgrading from. Because all these should have been in your database before the upgrade to 2.4 If you need the specs on the tables and fields let me know and I will get them to you. If you need more specific help email me and I will see what I can do.
Shadow |
|
|
|
|
| | |
| Posted: Sun Feb 01, 2004 7:08 pm |
|
|
| lexmails |
| Newbie |
|
|
| Joined: 31 Jan 2004 |
| Posts: 3 |
| Location: NY |
|
|
|
|
|
|
Thanks, Shadow. I upgraded from a version earlier than 2.3, I'm not exactly sure which version but I never had the text or banner ads. If you can give me the specifics on the tables and fields that would be great. I think and hope that is all I need.
Thank you so much!  |
|
|
|
|
| | |
| Posted: Sun Feb 01, 2004 8:15 pm |
|
|
| shadow |
| Addict |
|
|
| Joined: 16 Oct 2003 |
| Posts: 171 |
| Location: Virgin Islands |
|
|
|
|
|
|
Here it the layout for the tables
Table textads type MyISAM 7 fields
Field type Null default extra
id int 11 no auto_increment
username varchar 15 no
text varchar 150 no
url varchar 100 no
urlto varchar 100 no
clicks mediumint 5 no 0
views mediumint 5 no 0
Table banners type MyISAM 6 fields
Field Type Null default extra
id int 11 no auto_increment
username varchar 15 no
url varchar 100 no
urlto varchar 100 no
clicks mediumint 5 no 0
views mediumint 5 no 0
The number besides the type is the length/value for that field. You should be able to use this info and phpMyAdmin to set up the tables and fields. If you have any problems let me know
Shadow |
|
|
|
|
| | |
| Posted: Sun Feb 01, 2004 9:06 pm |
|
|
| lexmails |
| Newbie |
|
|
| Joined: 31 Jan 2004 |
| Posts: 3 |
| Location: NY |
|
|
|
|
|
|
Hi 
I'm a little confused about a couple of things.
I've gotten to the length/values but I'm not sure what to do after that.
Field type Null default extra
id int 11 no auto_increment ------- is the no for Null or Default?
username varchar 15 no
text varchar 150 no
url varchar 100 no
urlto varchar 100 no
clicks mediumint 5 no 0 ---------- What is the 0 for?
views mediumint 5 no 0
Other than that I have got it. |
|
|
|
|
| Posted: Mon Feb 02, 2004 1:22 pm |
|
|
| shadow |
| Addict |
|
|
| Joined: 16 Oct 2003 |
| Posts: 171 |
| Location: Virgin Islands |
|
|
|
|
|
|
This format doesn't show table heads very well. But the no is for not null the zero is for the default value and the auto_increment is for the extra.
Shadow |
|
|
|
|
| Posted: Tue Feb 03, 2004 7:52 pm |
|
|
|
Okay I just tried to create a table with the information you gave me and got this error message:
Error
SQL-query :
CREATE TABLE `textads` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`username` VARCHAR( 15 ) NOT NULL ,
`text` VARCHAR( 150 ) NOT NULL ,
`url` VARCHAR( 100 ) NOT NULL ,
`urlto` VARCHAR( 100 ) NOT NULL ,
`clicks` MEDIUMINT( 5 ) DEFAULT '0' NOT NULL ,
`views` MEDIUMINT( 5 ) DEFAULT '0' NOT NULL
)
MySQL said:
Incorrect table definition; There can only be one auto column and it must be defined as a key |
|
|
|
|
| Posted: Tue Feb 03, 2004 7:53 pm |
|
|
| lexmails |
| Newbie |
|
|
| Joined: 31 Jan 2004 |
| Posts: 3 |
| Location: NY |
|
|
|
|
|
|
| The last post was from me, I forgot to log in. |
|
|
|
|
|
|
