/    Sign up×
Community /Pin to ProfileBookmark

PHPbazarSales – manual tab insertion

Copy linkTweet thisAlerts:
Oct 02.2007

Hi all,

I searchin for anyone that has used or is using phpbazar. I am trying to install the “sales” addon for it but it aint workin. And its writers arent really supportive of it anymore since in went GNU.

Anyway i tried to install the table for sales in SQL file because they appear to be missing: this is the error message i get in salesadim:

[B]Table ‘myusername_phpbazar.phpbazar_sales’ doesn’t exist[/B]

read that they had to be manually added….tried that with this:

[b]DROP TABLE IF EXISTS sales;
CREATE TABLE sales (
id int(11) NOT NULL auto_increment,
userid int(11) NOT NULL default ‘0’,
timestamp int(14) NOT NULL default ‘0’,
ip varchar(40) NOT NULL default ”,
type varchar(10) NOT NULL default ”,
count int(6) NOT NULL default ‘0’,
amount double(16,4) NOT NULL default ‘0.0000’,
ordernumber varchar(25) NOT NULL default ”,
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM; [/b]

No go – still doesnt work – I am using phpbazar v.2.1 so if there is anyone here that knows what im talking about – i would so greatly appreciate any suggestions. Im no web pro but im not completely clueless, any instructions or time taken to reply wont be wasted…Thanks – Lea

to post a comment
PHP

5 Comments(s) ↴

Copy linkTweet thisAlerts:
@NightShift58Oct 02.2007 — What doesn't work at this point?

Does the "Create" fail or is the program still no working in spite of having successfully created the table?
Copy linkTweet thisAlerts:
@claritydigitalauthorOct 02.2007 — I had to manually insert the table into the SQL. When i go to sales admin it would come up with error message saying "table doesnt exist" that happened even after i put it in there manually and was happening the same before i put it in - so its basically not working. I searched all through my cpanel and cant find anywhere else for it to go, so this finds me here. My webmaster is sick and lives in a whole other continent and timeframe to me, so im trying to save myself some time and do it myself - I am very capable of adding things and deleting things, but i cannot write things in PHP - i can only use basic html - confused? me too...LOL

Any help would be so appreciated!
Copy linkTweet thisAlerts:
@MrCoderOct 02.2007 — Does the '[B]phpbazar_sales[/B]' table exist in the database '[B]myusername_phpbazar[/B]'?

Was the '[B]myusername[/B]' bit replaced by you or does it need changing?

Have you read any documentation that came with the add-on, such as install instructions?

<i>
</i>DROP TABLE IF EXISTS [B]sales[/B];
CREATE TABLE [B]sales[/B] (
id int(11) NOT NULL auto_increment,
userid int(11) NOT NULL default '0',
timestamp int(14) NOT NULL default '0',
ip varchar(40) NOT NULL default '',
type varchar(10) NOT NULL default '',
count int(6) NOT NULL default '0',
amount double(16,4) NOT NULL default '0.0000',
ordernumber varchar(25) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;


The above MySQL query creates a table called '[B]sales[/B]', your looking for a table named '[B]phpbazar_sales[/B]'..
Copy linkTweet thisAlerts:
@claritydigitalauthorOct 03.2007 — no it didnt come with instructions for troubleshooting - just installation, did everything and it didnt work, you are spot on mrCoder - but i dont know where the database is or where to insert the table? or if this is the table i should insert? but any help would be great - i am suprised that anyone responded - you guys are great.
Copy linkTweet thisAlerts:
@claritydigitalauthorOct 03.2007 — My programmer fixed it after a big sook sessions i had...LOL....but i want to say you guys are great, i have sought help on many forums including oscommerce forum, which i find i never get any help, people are selective about who they answer for some reason , its like they all know something i dont....LOL

Well thanks again guys - you have been great!

Cheers! Lea
×

Success!

Help @claritydigital spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.2,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,

tipper: @Samric24,
tipped: article
amount: 1000 SATS,
)...